Re: Using DFSORT to display binary and Packed Decimal values
Hi Kolusu That solved this problem. Thank you very much for your assistance Best wishes Jack On Thu, 21 Jul 2022 at 19:10, Sri h Kolusu wrote: > >>If I use 117,4,CH,LE,X'2021202F', it works as expected. But I do not > want to have a hard coded date. I have used on a different report > "118,10,BI,LE,DATE1(-)-90)" for dates with the "-mm-dd" format. > >>My interpretation of the DFSORT manual for a date on the "ddd" > format, is that I should use the DATE3 symbol, but it is not working. I > will keep reading the manual and I will keep trying on but, in the > meantime, does anyone has a suggestion? > > Jack, > > You need to use DATE3P which is a packed decimal format in +ddd format. > > So you can use > > INCLUDE COND=(009,2,CH,EQ,C'D ',AND, > 117,4,PD,LE,DATE3P-90) > > This will filter out the records that have last reference date <= current > date - 90 days > > Further if you have any questions please let me know > > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using DFSORT to display binary and Packed Decimal values
>>If I use 117,4,CH,LE,X'2021202F', it works as expected. But I do not want to >>have a hard coded date. I have used on a different report >>"118,10,BI,LE,DATE1(-)-90)" for dates with the "-mm-dd" format. >>My interpretation of the DFSORT manual for a date on the "ddd" format, is >>that I should use the DATE3 symbol, but it is not working. I will keep >>reading the manual and I will keep trying on but, in the meantime, does >>anyone has a suggestion? Jack, You need to use DATE3P which is a packed decimal format in +ddd format. So you can use INCLUDE COND=(009,2,CH,EQ,C'D ',AND, 117,4,PD,LE,DATE3P-90) This will filter out the records that have last reference date <= current date - 90 days Further if you have any questions please let me know Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using DFSORT to display binary and Packed Decimal values
Hi, By now, after more trial and errors and reading several bits of the DFSORT manual, I have been able to get the report that I wanted. But now I need something else. I want to produce a report with only the data sets that have not been referenced for over a year. The DCOLLECT record "D" "DATE LAST REFERENCED (ddd F)" is on position 113 (117 for a SORT field), with a length of four bytes. I think that this makes it format PD for SORT, and not CH as the manual states. If I use 117,4,CH,LE,X'2021202F', it works as expected. But I do not want to have a hard coded date. I have used on a different report "118,10,BI,LE,DATE1(-)-90)" for dates with the "-mm-dd" format. My interpretation of the DFSORT manual for a date on the "ddd" format, is that I should use the DATE3 symbol, but it is not working. I will keep reading the manual and I will keep trying on but, in the meantime, does anyone has a suggestion? Thank you, Regards, Jack On Wed, 20 Jul 2022 at 15:53, Jack Zukt wrote: > Thanks Kolusu > Jack > > On Wed, 20 Jul 2022 at 15:53, Sri h Kolusu wrote: > >> Jack, >> >> The link that nigel pointed out is an old one and does not have the >> updated the macros (encryption and other enhancements). Moreover the FTP >> link also does not work. I will fix the website not to refer to the FTP >> site. >> >> I will respond to you offline about the updated macros and JCL. >> >> >> Thanks, >> Kolusu >> DFSORT Development >> IBM Corporation >> >> >> >> -- >> For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN >> > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using DFSORT to display binary and Packed Decimal values
Thanks Kolusu Jack On Wed, 20 Jul 2022 at 15:53, Sri h Kolusu wrote: > Jack, > > The link that nigel pointed out is an old one and does not have the > updated the macros (encryption and other enhancements). Moreover the FTP > link also does not work. I will fix the website not to refer to the FTP > site. > > I will respond to you offline about the updated macros and JCL. > > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using DFSORT to display binary and Packed Decimal values
Jack, The link that nigel pointed out is an old one and does not have the updated the macros (encryption and other enhancements). Moreover the FTP link also does not work. I will fix the website not to refer to the FTP site. I will respond to you offline about the updated macros and JCL. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using DFSORT to display binary and Packed Decimal values
Thank you Nigel, I am going to have a look at it, Regards, Jack On Wed, 20 Jul 2022 at 15:11, Nigel Morton wrote: > I thought I had a job that did exactly this but I can't find it. However, > there are plenty of examples indexed at > https://www.ibm.com/support/pages/dfsort-icetool-papers-and-examples > including for DCOLLECT. > > On Wed, 20 Jul 2022 at 11:43, Jack Zukt wrote: > > > Hi, > > > > I am using DFSORT to process DCOLLECT Data Records. I am trying to > format a > > output record with the dataset name, volser, allocated space, creation > date > > and last ref date. > > On the DCOLLECT Data Record, the allocated space is on a binary format > and > > the date fields are all on packed decimal. I would like those to be > > reformatted to a character format as I want it to be readable. So far I > > have been reading the manual and have been on a trial and error process, > > with a lot of tries and a lot of errors. As this must be a simple thing > to > > do, I must be doing it all wrong. > > Ant help will be greatly appreciated, > > Best regards, > > Jack > > > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using DFSORT to display binary and Packed Decimal values
I thought I had a job that did exactly this but I can't find it. However, there are plenty of examples indexed at https://www.ibm.com/support/pages/dfsort-icetool-papers-and-examples including for DCOLLECT. On Wed, 20 Jul 2022 at 11:43, Jack Zukt wrote: > Hi, > > I am using DFSORT to process DCOLLECT Data Records. I am trying to format a > output record with the dataset name, volser, allocated space, creation date > and last ref date. > On the DCOLLECT Data Record, the allocated space is on a binary format and > the date fields are all on packed decimal. I would like those to be > reformatted to a character format as I want it to be readable. So far I > have been reading the manual and have been on a trial and error process, > with a lot of tries and a lot of errors. As this must be a simple thing to > do, I must be doing it all wrong. > Ant help will be greatly appreciated, > Best regards, > Jack > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Using DFSORT to display binary and Packed Decimal values
Hi, I am using DFSORT to process DCOLLECT Data Records. I am trying to format a output record with the dataset name, volser, allocated space, creation date and last ref date. On the DCOLLECT Data Record, the allocated space is on a binary format and the date fields are all on packed decimal. I would like those to be reformatted to a character format as I want it to be readable. So far I have been reading the manual and have been on a trial and error process, with a lot of tries and a lot of errors. As this must be a simple thing to do, I must be doing it all wrong. Ant help will be greatly appreciated, Best regards, Jack -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN