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

Hi Charles,

I haven't used that table function so I looked it up at https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqudfjobinfo.htm and I don't see any example where it passes '*' as a parameter.  The closest I saw was

SELECT * FROM TABLE(QSYS2.JOB_INFO(           )) X
 WHERE JOB_TYPE NOT IN ('SBS','SYS','RDR,'WTR')|)|

When I ran the above on a v7r3 box, it worked fine.

When I tried your version

 SELECT * FROM TABLE(QSYS2/JOB_INFO('*'))

I got

Message ID . . . . . . :   CPF503E       Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent  . . . . . . :   08/28/20      Time sent  . . . . . . : 13:27:53

Message . . . . :   User-defined function error on member QSQPTABL.
Cause . . . . . :   An error occurred while invoking user-defined function
  JOB_INFO in library QSYS2. The error occurred while invoking the associated
  external program or service program QDBSSUDF in library QSYS, program entry
  point or external name QSQJOBINFO, specific name QSQJOBINFO. The error
  occurred on member QSQPTABL file QSQPTABL in library QSYS2. The error code
  is 1. The error codes and their meanings follow:
    1 -- The external program or service program returned SQLSTATE 22023. The
  text message returned from the program is: JOB_STATUS_FILTER PARAMETER
  INVALID .

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /


On 8/28/2020 10:52 AM, Charles Wilt wrote:

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