felipunkz
forstie
/ PTF Cover Letters.sql
Last active
August 25, 2023 15:36
The request... show how SQL can be used to narrow the field down to those PTFs that have special instructions, and only return the special instructions. The following example focuses on what an admin might do AFTER loading PTFs, but BEFORE applying them.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Subject: PTF Cover Letters | |
| -- Author: Scott Forstie | |
| -- Date : April, 2023 | |
| -- Features Used : This Gist uses qsys2.ptf_info, SQL Alias, ltrim, rtrim(), dynamic SQL, SQL PL, PIPE | |
| -- | |
| -- Note: | |
| -- 1) Whether PTF Cover Letters exist on your IBM i is up to whomever ordered the PTFs | |
| -- Use the Copy PTF Cover Letter (CPYPTFCVR) command to bring in PTF cover letters | |
| -- https://www.ibm.com/docs/en/i/7.5?topic=ssw_ibm_i_75/cl/cpyptfcvr.html | |
| -- 2) The file QGPL/QAPZCOVER *FILE contains one member for each PTF Cover Letter |