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 Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
