RPG stored procedures

120 pts.
Tags:
AS 400
RPG
Stored Procedures
Remote client calls RPG stored procedure which invokes RPG program. I am then calling another program from initial program but when I make this call it does not return result set. Can I call one program from the called program?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 5  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.
  • TheRealRaven
    Yes. Program calls are extremely common, perhaps happening in the majority of cases.

    A missing result set could happen if one of the called programs is the source of the result set. If so, the called program should also be registered as a stored procedure and should be declared so that its result set is returned to the proper target.
    35,130 pointsBadges:
    report
  • ToddN2000
    We do it all the time. Go back and check the code thru debug and make sure it flows properly and all data is being handle/passed properly. When calling other programs, you need to make sure they are running as expected. Most of them should run Asynchronously and not via a batch process to handle the passing of data.
    132,840 pointsBadges:
    report
  • junekotey
    Thanks for feedback..in debugging with rdi I set up sep to Debug remote call. Message displays indicating the service entry Point was successfully set but when the sep is hit,the session Is started then the program gets terminated with message "DBGP004E Program terminated" "DBGP004E Program terminated"
    120 pointsBadges:
    report
  • TheRealRaven
    Too little info to say much. Everything sounds "normal" so far. Seems likely that the SEP should be removed, calls should be cleaned up including any AGs, then start fresh.

    Needs OS level, probably cume level, RDi level, CREATE PROCEDURE statements, flow description describing where result is created, and maybe more.
    35,130 pointsBadges:
    report
  • junekotey
    Thanks all for input...debug session working now..when debugging SQL procedures I had to set debug preference to always use the Debugger editor...select Windows>Preferences>Run/Debug> Compiled Debug>Debug Editors. Select the Always use Debugger Editor while debugging check box
    120 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.

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

Following

Share this item with your network: