Search found 805 matches
- Wed Nov 08, 2006 2:20 am
- Forum: JCL
- Topic: SORT query
- Replies: 3
- Views: 12311
rahul, Your "solution" makes no sense. SUM FIELDS=NONE is ignored with SORT FIELDS=COPY. You must use SORT or MERGE with a key in order for SUM FIELDS=NONE to eliminate records. The key determines the duplicates to be eliminated. If you sorted on positions 1-7 to try to keep only one Header and one ...
- Tue Nov 07, 2006 11:29 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Controlling Return Codes of SORT
- Replies: 1
- Views: 6234
- Fri Oct 27, 2006 8:33 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: A Sort question
- Replies: 1
- Views: 5757
- Wed Oct 11, 2006 8:45 pm
- Forum: JCL
- Topic: how to concatenate the datasets
- Replies: 2
- Views: 24765
- Mon Oct 09, 2006 10:13 pm
- Forum: JCL
- Topic: SORT query
- Replies: 3
- Views: 12311
Is there something unique about the header that identifies it (e.g. 'HDR' in positions 1-3) or is it just the first record of every file? Is there something unique about the trailer that identifies it (e.g. 'TRL' in positions 1-3) or is it just the last record of every file? Is the header and traile...
- Fri Sep 29, 2006 8:40 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT JCL - SORTING A VB FILE - INREC OUTREC PARSE BUILD
- Replies: 7
- Views: 63842
- Fri Sep 29, 2006 8:30 pm
- Forum: Admin Announcements
- Topic: STAR MEMBER AWARD - FOR SEPTEMBER 2006
- Replies: 3
- Views: 15020
STAR MEMBER AWARD - FOR SEPTEMBER 2006
Thanks, Krishna. Actually, I'm already a moderator of the DFSORT Forum. :) >Gift Coupon worth of Rs. 1000/- How much is that in U.S. dollars? Seriously, as an IBMer, it's probably better if I don't accept gifts but I appreciate the thought. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL.
- Thu Sep 28, 2006 9:12 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT JCL - SORTING A VB FILE - INREC OUTREC PARSE BUILD
- Replies: 7
- Views: 63842
Actually, this is a comma separated value (CSV) file. It has fields with variable positions. It might also be a VB file but I'm guessing it's really an FB file. You can use the following DFSORT job to do what you asked for. However, you'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 ...
- Fri Sep 22, 2006 12:45 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT article in z/Journal (Aug/Sept)
- Replies: 0
- Views: 4267
DFSORT article in z/Journal (Aug/Sept)
FYI, the Aug/Sept issue of z/Journal has a DFSORT article I wrote (with a picture of me and my pet rat Gracie, for those of you who are curious). You can access the article directly from: http://www.zjournal.com/index.cfm?section=article&aid=560 The z/Journal homepage is at: http://www.zjournal.com/
- Wed Sep 20, 2006 9:07 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Query in dfsort / icetool
- Replies: 2
- Views: 7268
- Tue Sep 19, 2006 9:19 pm
- Forum: JCL
- Topic: How get totals at bottom of the files
- Replies: 1
- Views: 6589
- Mon Aug 21, 2006 9:01 pm
- Forum: JCL
- Topic: How to count the no of records through JCL
- Replies: 1
- Views: 9775
See the "Display the number of input or output records" Smart DFSORT Trick at:
http://www.ibm.com/servers/storage/supp ... vs/tricks/
http://www.ibm.com/servers/storage/supp ... vs/tricks/
- Wed Jul 26, 2006 8:54 pm
- Forum: JCL
- Topic: ICETOOL & DFSORT
- Replies: 1
- Views: 18055
It is known that DFsort + added functionalities -> ICETOOL No, that's not the right way to describe it. DFSORT's ICETOOL has its own set of functions, some of which can be done directly by DFSORT and many of which can't. ICETOOL actually uses its own code and logic along with calls to DFSORT. What ...
- Tue Jul 04, 2006 9:00 pm
- Forum: JCL
- Topic: Help required for a sort step.
- Replies: 5
- Views: 14569
wanted to know where does this code takes care of having maximum of those (count-9) records date field? Well, it's rather tricky. Let's just take the Cereals records for an example. T1 will have: Cereals 04 T2 will have: Cereals 3/14/2001 225 225 Cereals 01 Cereals 3/17/2001 3 3 Cereals 02 Cereals ...
- Mon Jul 03, 2006 8:32 pm
- Forum: JCL
- Topic: SORTD OUTREC Reformatting Query
- Replies: 3
- Views: 16704