Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
calling stored procedures and returning data
Gianni, After talking with Fujitsu they said that a stored procedure returning a unkown number of rows can not be done and that I would have to embed the stored procedure sql in to the cobol program and use a cursor and fetch to retrieve each row. Andy- hillstax
- Post #7
- Forum: COBOL General discussion
-
calling stored procedures and returning data
Gianni, Thanks for looking in to this. I would eventually like a Fujitsu Cobol solution. Once again thanks for you time. Andy,- hillstax
- Post #6
- Forum: COBOL General discussion
-
calling stored procedures and returning data
That sql statement in the procedure division should read call reexemptions instead of execute reexemptions. I was trying something out when I copied the code.- hillstax
- Post #4
- Forum: COBOL General discussion
-
calling stored procedures and returning data
Gianni, Thanks for the response. The database, tables and stored procedures are on the same sql server 2000. I'm using Fujitsu Cobol V6.1, the enterprise version which does have power cobol with it but I need to eventually wrap this cobol with object oriented code so that is why I'm not...- hillstax
- Post #3
- Forum: COBOL General discussion
-
calling stored procedures and returning data
We have a system that we are trying to bring up. The cobol was Microfocus and I'm in the process of converting it to Fujitsu. right now I've been running in to a problem with calling stored procedures that do a select and should return data. The stored procedure has been debugged and works...- hillstax
- Thread
- Replies: 6
- Forum: COBOL General discussion
