Anees2007
New User
Joined: 15 Aug 2007 Posts: 1 Location: Hartford
|
|
|
|
Hi,
Iam trying to call a stored procedure from another stored procedure in COBOL. The Calling stored procedure is used to Insert/delete/update the records in DB2 database. The called stored procedure is used to generate a unique system generated number(it works fine i tested this with a sample ASP page).The input field parameters are entered by user from online ASP web pages and passed to SP using DB2SPC.See the sample code.
Exec SQL
Call Storedprocname ( :field1,:field2, :field3:ReturnField)
End Exec
After calling the stored procedure, the ReturnField is inserted along with the other fields that are entered by the user from online screen.
But when i tried binding this stored procedure iam getting a -408.
Iam not sure is something wrong with syntax of Call statement,
your help is very much appreicated.
Thanks
Anees. |
|