Displaying the data collected

 

After collecting data in the job accounting journal, you can write the journal entries to a file and display them.

To do this, follow these steps:

In the following example, the job accounting journal name is QACGJRN.

1. Create a copy of the system supplied model outfile for the accounting journal. QAJBACG4 is the model outfile for the *TYPE4 outfile format.
   1. Command: Create Duplicate Object (CRTDUPOBJ)

      CRTDUPOBJ OBJ(QAJBACG4) FROMLIB(QSYS) OBJTYPE(*FILE) TOLIB(QTEMP)
         NEWOBJ(MYJBACG4)

2. Dump the journal entries to the outfile that you just created. In the following example only the 'JB' or job type journal entries are being dumped.
   1. Command: Display Journal (DSPJRN)

      DSPJRN JRN(QACGJRN) ENTTYP(JB) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4)
         OUTFILE(QTEMP/MYJBACG4)

3. Start an SQL session. Then use the SELECT command from within the SQL session to choose the fields you want to display.
   1. Command: Start Structured Query Language (STRSQL)

      STRSQL SELECT JAJOB, JAUSER, JAUSPF, JACDE, JACPU FROM QTEMP/MYJBACG4

You can display a list of field names interactively or to a file by creating and running a query using the Work with Queries (WRKQRY) command.

 

Parent topic:

Managing job accounting