× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2022

Re: Using SQL's JOB information queries - how can I see the command used on a submitted job?

Le 22/01/2022 à 18:00, a4g atl a écrit :
I looked the the details and it does not have the
full command with the parms. It has the program names only.

Not sure to understand what you mean. Here is the joblog:

                             Display All Messages
System:   PUB400
Job . . :   CALL          User . . :   DIMARCO       Number . . . :   885331

 >> CALL PGM(PROGRAM) PARM(PARAMETER1 PARAMETER2)
    Program PROGRAM in library *LIBL not found.
    Error found on CALL command.
    Job ended. Cancel message received at command processor.
    Job 885331/DIMARCO/CALL ended on 01/22/22 at 17:45:44; 0,007 seconds used;
      end code 20 .


And here is the SQL statement output:

SELECT A.MESSAGE_TEXT FROM
TABLE(QSYS2.JOBLOG_INFO('885331/DIMARCO/CALL')) A WHERE
A.MESSAGE_TYPE = 'REQUEST';

using iACS
MESSAGE_TEXT
CALL PGM(PROGRAM) PARM(PARAMETER1 PARAMETER2)

using STRSQL
MESSA00008
CALL PGM(PROGRAM) PARM(PARAMETER1 PARAMETER2)


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.