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.
Call Storedprocname ( :field1,:field2, :field3:ReturnField)
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,