> I request your help to merge all cert-related record types from > IRRDBU00 (hopefully just the ones listed here - 0207, 0500, 0560, > 0561, 0562, 1560), and dedupe it based on the unique cert "name" field. > Once done, I need help printing out all the other fields mentioned > above so as to get a table of all certs with all related info in a > readable format (a CSV would be great!). > And finally, the ability to filter the output based on 'n' days, so > that I can see what certs are expiring in the next 'n' days. > > Thank you so much for your help, I'm hoping this will benefit many > folks on the list. >
Vignesh, There is an earlier discussion similar to your requirement which dealt with user events. Here is a link to that topic https://groups.google.com/d/msg/bit.listserv.ibm-main/V-Im5LCmV7Y/5T9yzeVOAgAJ You can follow the same approach for your record-types and build 1 common record format and pad it with spaces for the missing values. You can use SUM FIELDS=NONE to eliminate the duplicates. If you have trouble converting that sample, Please send me a sample of the input (1 record per type at the least) and I can show you a way to do it. Thanks, Kolusu ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
