Invoking stored procedures returning result set from COBOL/RPG pgm

pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following