Re: QSH db2 command and qsys2.joblog_info() - exit status 1

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Nobody has any thoughts?

So more info...

> From an interactive QSH, (on the problem box)
db2 "select * from table (qsys2.joblog_info('*'))"

returns
0 RECORD(S) SELECTED.

Works fine on another box...

Charles


On Thu, Aug 27, 2020 at 2:23 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> Any thoughts as to why this would return with an exit status of 1 and an
> outfile that says "0 RECORD(S) SELECTED."?
>
> QSH CMD('db2 "select * from table (qsys2.joblog_info(''*''))" >
> loglog.txt')
>
> running
> select * from table (qsys2.joblog_info('*'))
>
> in STRSQL returns data in the same 5250 session...
>
> This works fine
> qsh cmd('db2 "select * from sysibm.sysdummy1" > test.txt')
>
> And the problem command works fine when run on a different system...
>
> Thanks!
> Charles