SQL Option SQL option SRTSEQ=*LANGIDSHR

Tags:
AS/400
PGM
SQL
I have PGM1 with SQL option SRTSEQ=*LANGIDSHR.
Now from PGM1 I am calling PGM2 (PGM2 is a *PGM object with *InLR = *On) where SQL option SRTSEQ=*HEX
When controls comes back to PGM1, what would be the SRTSEQ?
1

Answer Wiki

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

It would remain *LANGIDSHR as this is the calling program to the lower level PGM2.

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.
  • TheRealRaven
    It doesn't change just because another program was called. If it was *LANGIDSHR before the CALL, it'll be that after the CALL completes.

    If it changed, it could seriously mess up a FETCH under an ORDER BY in PGM1.
    35,650 pointsBadges:
    report
  • BibekMajilla
    Thank you for the quick reply.
    90 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: