 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 3 matches |
| Author | Message |
|---|---|
 Topic: Help - Cob/DB2 stored procs - multiple result sets |
|
| jcr Replies: 5 Views: 6799 |
 Forum: Application Programming Posted: Tue Mar 21, 2006 2:57 pm Subject: Help - Cob/DB2 stored procs - multiple result sets |
| Thanks, but we can already determine the number of result sets returned. The DESCRIBE CURSOR statement populates the SQLDA with this information. SQLD contains the number of result sets. My issue is h ... | |
| Topic: Help - Cob/DB2 stored procs - multiple result sets |
|
| jcr Replies: 5 Views: 6799 |
Forum: Application Programming Posted: Tue Mar 21, 2006 2:52 am Subject: Help - Cob/DB2 stored procs - multiple result sets |
| Hi,
This is how it will work: 1. In the calling program, declare 01 LOCVAR SQL TYPE IS RESULT-SET-LOCATOR VARYING. 2. Call stored procedure using CALL statement. EXEC SQL CALL p ... |
|
| Topic: Help - Cob/DB2 stored procs - multiple result sets |
|
| jcr Replies: 5 Views: 6799 |
Forum: Application Programming Posted: Mon Mar 06, 2006 5:55 pm Subject: Help - Cob/DB2 stored procs - multiple result sets |
| I am new to stored procs, as is the company I am working for. We will
be writing stored procs which may return any number of result sets. After referring to the DB2 manuals etc, I have no trouble un ... |
|
All times are GMT - 5 Hours |