Re: DCR request - order any PTF not part of any cum or group

Simple CL to get the CSV and populate a db2 file:
(i did this pre-HTTP support in SQL)

PGM
/* +
CREATE TABLE YourLibrary/SF97730 ( +
PRODUCT CHAR (7 ) NOT NULL WITH DEFAULT, +
OSRELEASE CHAR (6 ) NOT NULL WITH DEFAULT, +
PTF CHAR (7 ) NOT NULL WITH DEFAULT, +
PKG CHAR (6 ) NOT NULL WITH DEFAULT, +
AVAILDATE DATE NOT NULL WITH DEFAULT, +
MRIFEATURE CHAR (4 ) NOT NULL WITH DEFAULT, +
REPLACEDBY CHAR (7 ) NOT NULL WITH DEFAULT, +
CATEGORIES CHAR (3 ) NOT NULL WITH DEFAULT, +
ABSTRACT CHAR (75 ) NOT NULL WITH DEFAULT +
) +
+
*/


LIBHTTP/HTTPAPI +
URL('http://www-01.ibm.com/support/docview.+
wss?uid=nas4SF97730&aid=3') +
DOWNLOAD('/home/PTFs/httpapi.97730.csv')

CPYFRMIMPF FROMSTMF('/home/PTFs/httpapi.97730.csv') +
TOFILE(YourLibrary/sf97730) +
MBROPT(*REPLACE) +
RCDDLM(*LF) +
STRDLM(*NONE) +
RMVBLANK(*BOTH) +
RPLNULLVAL(*FLDDFT) +
RMVCOLNAM(*YES)

endpgm




Rob Berendt wrote on 2/22/2017 8:17 AM:

If IBM would finish this RFE
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=88260
which is to create an XML listing of PTF's available at IBM. Why XML? The
PTF groups are available in XML format. This is what enables IBM to add
services like Group_PTF_Currency. If you use the "generate SQL" against
that you'll see what I mean.
Once they do that then it should be quite easy to do an exception join
between that list and the list available via PTF_Info and go from there.

But if you don't want to wait you can download the PTF listing in CSV
format.
http://www-01.ibm.com/support/docview.wss?uid=nas8N1021657
IBM i 7x0 PSPs
FIX SUMMARY LISTING FOR VERSION 7 RELEASE x.0
Ctrl-End to go to the bottom of the page.
Look for a file like SF977x0.csv

Replace x with the current release you are on.

Rob Berendt