Sort it first with the SUM FIELDS=NONE option.

RON HAWKINS
Director, Ipsicsopt Pty Ltd (ACN: 627 705 971)
m+61 400029610| t: +1 4085625415 | f: +1 4087912585

-----Original Message-----
From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Ron 
Thomas
Sent: Wednesday, 22 May 2019 08:26
To: [email protected]
Subject: [IBM-MAIN] Sort - File split

Hi . 

i have FB file with lrecl 5000 and here below is layout. key is first 11 bytes 
PO number

102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
102016    |  31859949  |            |  1613QTTR            |  1
104152    |  32412273  |            |  2373QTBO            |  1
104152    |  32412273  |            |  2373QTBO            |  1
104152    |  32412273  |            |  2373QTBO            |  1
104152    |  32412273  |            |  2373QTBO            |  1
104152    |  32412273  |            |  2373QTBO            |  1

Here i need to pull 100 PO numbers . one PO has multiple rows  & hence  when we 
pull all details of one PO should come in the output file. So how in DFSORT 
this can be done ?

Thanks
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

Reply via email to