Home > IT Answers > DataCenter > Invoking stored procedures returning result set from COBOL/RPG pgm
BAGray
0 pts.
 Invoking stored procedures returning result set from COBOL/RPG pgm
COBOL, SQL
I am currently trying to invoke an SQL procedure (Language SQL) that returns a result set (open cursor)from within a COBOL or RPG program, all residing on an AS/400. However, I cannot find the command that will associate the result set with any mnemonic that I can issue FETCH/CLOSE commands against. Can anyone shed some light on this? Thanks in advance, Bernard Gray Lead Programmer/Analyst First American Corporation

Software/Hardware used:
ASKED: August 4, 2005  8:08 AM
UPDATED: August 5, 2005  8:23 AM
RELATED QUESTIONS
Answer Wiki:
CC .00 C/Exec SQl 0865.00 C+ Fetch Next 0866.00 C+ From DynamCsr 0867.00 c+ into :PDS900 CC .00 c/End-exec 00 DPDS900 E DS EXTNAME(shpctlpf) PDS900 is an external data structure to receive the next record.
Last Wiki Answer Submitted:  August 5, 2005  8:23 am  by  AS400programmer   0 pts.
All Answer Wiki Contributors:  AS400programmer   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _