Rob / Bryan,
I just want to confirm.
The .csv file, for which ever release, contains every PTF available for that release.
I downloaded all 3 .csv files, 71, 72, 73.
V7R1 - 16,289 PTFs
V7R2 - 7,270 PTFs
V7R3 - 3,162 PTFs
Looking at the package field, if it states *NONE, these would be any PTF not part of a CUM or group.
Is this correct?
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Wednesday, February 22, 2017 12:00 PM
To: Midrange Systems Technical Discussion
Subject: Re: DCR request - order any PTF not part of any cum or group
Very good!
Then you can clean that file and remove:
- All the superseded ones.
- Those for LPP's you do not have.
- Those you already have.
And append that on to a list containing the cume (SF99730 for 7.3) and the All Groups group (SF99731 for 7.3) and do the SNDPTFORD.
I have to repeat this caveat:
You may not want to do this because:
- Some may be "toggle" ptf's (as described earlier in this thread).
- Some may not have had many guinea pigs who downloaded it before you.
But, knowing that, this method would work.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Bryan Dietz <bdietz400@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/22/2017 11:51 AM
Subject: Re: DCR request - order any PTF not part of any cum or
group
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
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
midrange.com
