How to read data from a stored procedure in RPGLE

15 pts.
Tags:
RPGLE
RPGLE Stored Procedures
Stored Procedures
How do I read data from a stored procedure?

Answer Wiki

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

See SQLRPGLE – Result Set and any number of other links. Pay special attention to the statement “The interfaces that can work with stored procedure result sets include JDBC, CLI, and ODBC.”

You can call stored procs from SQLRPG. But if you want to process a result set rather than accessing an updated parm value, you need to code SQL CLI APIs. Result sets are intended for ODBC type functions.

Tom

Discuss This Question: 2  Replies

 
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
  • CitizenJoe
    Thanks Tom.
    15 pointsBadges:
    report
  • TomLiotta
    FWIW, you're welcome. I'm pretty sure it wasn't what you wanted for an answer. Note that if you have written ODBC in perhaps VB, it's not too bad doing the same thing with SQL CLI. The APIs are intended to be mostly standard for any language/platform. CLI APIs can be called from RPG, COBOL, C, etc. Not particularly fun when you first find out that that's what they're often used for. Tom
    125,585 pointsBadges:
    report

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