Need to trim results in stored proc call (Rexx-specific?)
Issue #19
resolved
In the following test output, I do not expect the "USRLIBL" key in the output to have trailing spaces. I do not believe this happens during HTTP rest calls and may be isolated to invocations via stored proc (I am using DB2JSON.DB2PROCJR) and possibly even Rexx-based calls.
***********************************************
*****RTVJOBA ERROR:
***********
in:
{"script":[{"cmd":{"exec":"CHGLIBL LIBL(DB2JSON QTEMP) CURLIB(DB2JSON)"}},{"cmd":{"rexx":"RTVJOBA USRLIBL(?)"}}]}
********************
output:
{"script":[{"cmd":["CHGLIBL LIBL(DB2JSON QTEMP) CURLIB(DB2JSON)"]},{"cmd":["STRREXPRC SRCMBR(CMDIO) SRCFILE(DB2JSON/QREXSRC) PARM('3 RTVJOBA USRLIBL(?)')",{"records":[{"USRLIBL ":"DB2JSON QTEMP"}]}]}]}
****************************************************
Comments (2)
-
Account Deleted -
reporter - changed status to resolved
Verified. Closing. Thank you!
- Log in to comment
Ok, fix for remote via db2procjr (laptop).
Generally, stored procedure db2procjr path was intended for remote development. Not an async interface. Many CCSID, other problems, slow, etc. Should work, but not tested much by me. Thanks for help.