View previous topic :: View next topic
|
Author |
Message |
pshongal
New User
Joined: 14 Jun 2012 Posts: 96 Location: India
|
|
|
|
Hi All,
I have a small rexx utility to get sql error code as below.
If the program abend output shows sql code as 80N, my tool will get proper sqlcode as -805. This is just to help freshers in the team.
Now, I would like to add feature such that, it will take them to Quick reference also. So when they call my tool, it should convert it to proper code (which it is doing now) and then take them directly to QW as if executing "QW -805". How can I do it?
Thanks. |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
It would be easier (and wiser) to teach "freshers in the team" to do:
Code: |
01 WS-SQLCODE PIC -999.
MOVE SQLCODE TO WS-SQLCODE
DISPLAY ' SQLCODE: ' WS-SQLCODE |
If you really want, you can try:
Code: |
Address ISPEXEC "SELECT CMD(%QW PRM('-805'))" |
|
|
Back to top |
|
|
pshongal
New User
Joined: 14 Jun 2012 Posts: 96 Location: India
|
|
|
|
Thanks a lot Marso. |
|
Back to top |
|
|
|