IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER
by 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
by 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
Return to DFSORT/ICETOOL/ICEGENER
-
- Find records with any digit followed by D
by RalphEagle » Wed Feb 20, 2019 8:45 pm
- 8 Replies
- 1544 Views
- Last post by enrico-sorichetti
Fri Feb 22, 2019 9:48 pm
-
- SORT or ICETOOL to merger 2 80 byte records.
by rahulkrddd » Sat Jul 28, 2018 3:39 pm
- 10 Replies
- 5907 Views
- Last post by NicC
Tue Jul 31, 2018 2:07 pm
-
- Identify / Extract Upper case records and Lower case records
by ragsara » Tue Jun 07, 2016 3:41 am
- 4 Replies
- 3612 Views
- Last post by BillyBoyo
Wed Jun 08, 2016 2:56 am
-
- Extract records by comparing files
by MFsys » Thu Jul 22, 2010 6:44 pm
- 11 Replies
- 6255 Views
- Last post by MFsys
Fri Jul 30, 2010 12:54 am
-
- How to extract records from binary field
by Jayakumar CR » Mon Jan 16, 2012 12:11 pm
- 1 Replies
- 3829 Views
- Last post by BillyBoyo
Mon Jan 16, 2012 1:17 pm