IBM / db2sock-ibmi

An asynchronous PASE Db2 and IBM i integration library
MIT License
4 stars 7 forks source link

Why is uname coming back blank from stored proc call? #20

Closed kadler closed 6 years ago

kadler commented 6 years ago

Original report by Jesse G (Bitbucket: ThePrez, GitHub: ThePrez).


Other commands (tested echo, ls) seem to work, but uname comes back empty. Fully-qualifying uname to /QOpenSys/usr/bin/uname or /usr/bin/uname do not seem to make a difference. "-a" also renders a blank result.

***********************************************
*****uname:
***********
in:
{"script":[{"cmd":{"qsh":"uname -s"}}]}
********************
output:
{"script":[{"cmd":["uname -s",{"records":[{"R1":""}]}]}]}

****************************************************
kadler commented 6 years ago

Original comment by Jesse G (Bitbucket: ThePrez, GitHub: ThePrez).


Verified. Closing. Thank you!

kadler commented 6 years ago

Original comment by Tony Cairns (Bitbucket: rangercairns, GitHub: rangercairns).


remote ... uname -s (laptop db2procjr)

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.

#!bash

=============================
test5000_sql400json_procjr64 ../json/j0362_cmd_qsh_uname
=============================
input(5000000):
{"cmd":{"qsh":"uname -s"}}

output(62):
{"script":[{"cmd":["uname -s",{"records":[{"R1":"OS400"}]}]}]}

result:
success (0)