Skip to content

New functions and fixes to my popular SQLTOOLS Function Iibrary

Latest

Choose a tag to compare

@bobcozzi bobcozzi released this 22 Feb 18:51
0fc26f1

This release fixes several UDTF and consolidates the ACTJOB_LIST function, which now returns active job information that a developer would need, like logging, message queue, library list, and more.

New PRTF_LIST (List Printer Files) shows you the *PRTF file attributes
New PRTDEV_LIST (List Printer Devices) shows you a list of active and inactive PRINT device descriptions and their status.
Added new "Not Authorized to Object" handlers in PRTF_LIST and JOBD_LIST. Will continue to implement that feature as I update the existing functions over time.

Remember, you do not need the .src files shown below, only the correct .SAVF for your release of IBM i. If you have IBM i V7R3 or later, use the SQLTOOLS.SAVF if you are still on IBM i V7R2, then use SQLTOOLS72.SAVF.
To install:

  1. DLTLICPGM 2COZST3 /* can be skipped if installing for the first time */
  2. RSTLICPGM 2COZST3 *SAVF SAVF(QGPL/SQLTOOLS)

If you have V7R2, then obvously, use SAVF(QGPL/SQLTOOLS72) instead.