[Default] On 25 Sep 2020 09:54:45 -0700, in bit.listserv.ibm-main [email protected] (Ron Thomas) wrote:
>Hello > >We are using DFSORT utility to extract the latest record for a store/item/po >and below is the sample file > >item_nbr| Store_nbr|Po_nbr|item_date|mode| >000000604|9137|1100276393|2017-12-26|00007|DSD | >000000604|9137|1100278550|2018-01-09|00006|DSD | > >Here we need to pull the 2'nd record to the Output as this is the latest date >. > >Could someone please let me know how to achieve the same Given the obscurity of the control statements (quick tell me what field is 1,4,CH) why not write the thing in a language that has access to the descriptions of the fields being used? We are not in the era of 22K DOS360 partitions, 100K MVT regions or 4 megabyte MVS regions anymore. PL1 and COBOL both generate fairly efficient code and when the tool becomes more than one off wonder, someone else can pick up the program and have a fighting chance of understanding what was being done. Clark Morris > >Regards >Ron T > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
