Hi. We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is at position 65 of length 10 bytes . We need to pull those item nbrs which has same UPC,Vendor nbr ,State Code but there is price difference. Could anyone let me know how this to be done using dfsort.
Input file :- ITEM NUMBER UPC_NBR VendorNbr STATE_CODE BUY_PRICE 500000338 789997580026.00 36052910 DF 96.12 500000338 789997580026.00 36052910 DF 96.12 500000338 789997580026.00 36052910 DF 95.12 500000318 789997580026.00 36052910 DF 95.12 500000318 789997580026.00 36052911 DF 95.12 500000318 789997580026.00 36052911 DF 95.12 Desired o/p 500000338 789997580026.00 36052910 DF 96.12 500000338 789997580026.00 36052910 DF 96.12 500000338 789997580026.00 36052910 DF 95.12 Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN