![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGfWBlI_HCa5LD4cDL5WDLfnRaXZo2PaNT_EdcI8pJMCGQ0-FwSDthQ9oEZ1274BJE94eamd6KlkZjKMuA4OBHbvqO3bH8zOazfHEgrQAxy-zLioVvFrtRy0dSHLv0Sjz56hzn1j_0GOyyHnjXtVIQsA8x9PW6j8ag-NCZugBVgJj0s31I9Lf_o0ay/s200/sql.png)
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')) ; |