Do you need to pull 100 specified numbers, 100 random numbers, or the first 100 numbers?
If the first 100: Sort on key with EQUALS specified. Add a sequence number to the output record and use the WHEN=GROUP function to increment the sequence number only when the key changes. Stop when the sequence number reaches 100. > -----Original Message----- > From: IBM Mainframe Discussion List <[email protected]> On > Behalf Of Ron Thomas > Sent: Tuesday, May 21, 2019 3:26 PM > To: [email protected] > Subject: 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 ? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
