One of the SQL table functions I use the most is the ACTIVE_JOB_INFO, which is used to list all of the active jobs in any partition.
In IBM i TR4 and 7.3 TR10 a new parameter, DETAILED_INFO, was added to the Table Function. This controlled the number of columns that were returned in the results. When it was introduced there were the following options
— Default
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO()) ;
— All columns returned
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘ALL’)) ;
— QTEMP info returned only
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘QTEMP’)) ;
— Minimum info
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘NONE’)) ;
Read more »
