Handling return sets from COBOL stored procedures in JAVA invoking program
Hi, I need to handle the return set from COBOL stored procedure from my invoking Java program. I do not know, how many rows the stored proc SQL fetches.I have declared the cursor in that proc, but i don't know how to return the rows the cursor has opened and I don't know how to handle the return set from the proc in my java code.
My main problem with that proc is that whether I can retun the result set from the proc without closing the cursor in that proc or I have to fetch that rows to some host variables in that proc and move that to out parameter fields,then close the cursor in the proc.
Do I need to have the out parameter for returning the result sets from COBOL stored proc to invoking java prog,and If so, what will be the data type for that
Another doubt is that , do there is any parameter type like SYSREF CURSOR (which is in oracle stored procedures) in DB2.I am confused about handling the return sets in my java prog.
I am working in DB2 database, OS/390 environment.
Can anyone tell me how to handle the result set from cobol stored proc in my invoking java program with an simple example.
By Shawn Chidester in forum Database
Last Post: 06-25-2001, 03:23 PM
By Dave Havrda in forum Database
Last Post: 05-07-2001, 05:19 PM
By Alp Guner in forum Database
Last Post: 03-01-2001, 10:49 PM
By John Canny in forum authorevents.vieira
Last Post: 01-26-2001, 10:57 AM
By Julio Cesar Garcia Mendivil in forum Database
Last Post: 05-17-2000, 12:07 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL