[SOLVED] Create Synonym against DB2/LUW stored procedure
Hi all,
I have a stored procedure in my DB2/LUW 9.1 database that prepares a brief case summary when given a case id. The skeleton of this is below: -------------------------------- Create Procedure ANTOX.CASE_ABSTRACT (IN c_id INTEGER, OUT abstr VARCHAR(2000), OUT o_err INTEGER ) Specific CASE_ABSTRACT Reads SQL Data Language SQL AB: BEGIN DECLARE temp_abst VARCHAR(2000); DECLARE v_err INT DEFAULT 0;
OPENQ: BEGIN -- Get the open date and time and the caller's full name --- a lot of steps to build temp_abst --- SET abstr = temp_abst;
RETURN abstr, o_err; END AB! -------------------------------- The stored procedure works when I call it a DB2 user defined function as well as a direct call in Advanced Query Tool.
I have attempted to create a synonym for this stored procedure using WF Dev Studio 8007 but get the following error when the new synonym process gets to the build synonym. -------------------------------------------------------------- (FOC1400) SQLCODE IS -104 (HEX:FFFFFF980 :[42601][IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "," was :found following "NTOX.CASE_ABSTRACT (". Expected tokens may include: " :". SQLSTATE=42601 (FOC1405) SQL PREPARE ERROR --------------------------------------------------------------
I am going to revisit my earlier attempt to build it using the Synonym Editor, but if I have the same issues I had earlier with that approach I may be posting those issues here later.
Thanks in advance. HaroldThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.1.0.1 M Windows Server 2008 PDF, HTML, Excel