IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Calling Stored procedure from another stored procedure


IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Anees2007

New User


Joined: 15 Aug 2007
Posts: 1
Location: Hartford

PostPosted: Tue Feb 19, 2008 7:59 pm
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Feb 19, 2008 11:02 pm
Reply with quote

Hello Anees and welcome to the forums,

Have you looked up what causes the -408? At the top of the web page there is a "Manuals" link and one of the manuals is DB2 Messages & Codes.

This will give the details of the -408 (which basically says there is a data type incompatability).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 


Similar Topics
Topic Forum Replies
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
No new posts Calling an Open C library function in... CICS 1
No new posts calling a JCl inside a JCL JCL & VSAM 3
No new posts Calling IEHPROGM from REXX CLIST & REXX 7
Search our Forums:

Back to Top