How to extract 2 records for each digit in 1st byte



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: How to extract 2 records for each digit in 1st byte

Postby csepearl » Wed Jun 03, 2015 2:37 am

One another way to do it is use Icetool

SELECT FROM(IN) TO(OUT) ON(1,1,CH) FIRST(5)
csepearl
 
Posts: 3
Joined: Tue Jun 02, 2015 5:12 am
Has thanked: 0 time
Been thanked: 0 time

Re: How to extract 2 records for each digit in 1st byte

Postby BillyBoyo » Wed Jun 03, 2015 3:12 am

Yes. FIRST(5)? Also, if you look at the messages from the step, you'll see you got EQUALS, so rather than any two records (or five) you'll get the first two (or five).
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post