Search found 43 matches
- Wed Nov 20, 2013 11:49 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT - update count in multiple trailers of same dataset
- Replies: 4
- Views: 6722
nachiyappan, Use the following DFSORT JCL which will give you the desired results. I assumed that your input has LRECL=80 and RECFM=FB //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * 01 FILER HEADER 02 BATCH HEADER 1 10 DETAIL RECORD 10 DETAIL RECORD 10 DETAIL RECORD 20 000002 BATCH TRAI...
- Thu Jan 03, 2013 11:55 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT - Get the sorted data based on Julian Date Condition.
- Replies: 1
- Views: 3939
krunal7878, Use the following DFSORT JCL which will give you the desired results. Step0100 will build dynamic control cards when the current date is 2nd of every month and it will build cards with prior months, begin and end dates. Step0200 will run using the control cards created above. If the run ...
- Tue Sep 18, 2012 4:56 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: How to Split the record in two part and remove the duplicate
- Replies: 6
- Views: 8607
William Collins, Unless I am missing something isn't it a simple case of finding MIN and MAX for each key? Assuming the data is already sorted on the Key (1,5) , the following DFSORT JCL will give you the desired results. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * 019520000000001000...
- Tue Jul 10, 2012 12:36 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORTCARD help
- Replies: 6
- Views: 9922
- Thu Nov 18, 2010 9:41 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT: Reformat data
- Replies: 3
- Views: 6032
- Sat Oct 30, 2010 1:12 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort on date
- Replies: 6
- Views: 11390
Jairam_baju, With z/OS DFSORT V1R10 PTF UK90025 or z/OS DFSORT V1R12 PTF UK90026 (Oct, 2010), DFSORT can now add days to a given date quite easily like shown below. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * ----+----1----+----2----+----3----+----4----+----5 20101029 //SORTOUT DD SY...
- Wed Jul 07, 2010 9:14 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Reformatting and calculating time and date values
- Replies: 3
- Views: 11105
Hello Skolusu, One correction I have to add, but maybe that happened because of the short time of your answer. The difference in runtime between 02000268 and 02000310 is not 1.42 secs, as your solution presents, but only 0.42 secs. You calculated the difference between the hhmmss-part of the timest...
- Wed Jul 07, 2010 1:18 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Reformatting and calculating time and date values
- Replies: 3
- Views: 11105
Martin, The following DFSORT JCL will give you the desired results. I assumed that your input is FB recfm and 80 byte LRECL and the time difference can only span over 24 hours. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * ----+----1----+----2----+----3----+----4----+----5----+----6---...
- Wed Apr 14, 2010 9:27 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT: Reformat data
- Replies: 2
- Views: 5095
simo78, use the following DFSORT JCL //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DATA,DLM=$$ //AC01 EXEC AB13C1231 //AB01 EXEC AB88P001 //AB02 EXEC AB88P002,P1=AB //UNCAT EXEC PGM=IDCAMS //ABZ EXEC A345B105,P1=AB,M=Z //ABNH EXEC A345B105,P1=AB,M=NH //ABGBH EXEC A345B105,P1=AB,M=GBH //A...
- Tue Mar 30, 2010 9:24 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort jcl - report writer queries using OUTREC
- Replies: 5
- Views: 16225
- Tue Mar 30, 2010 9:11 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Query for an utility to copy records on condition
- Replies: 3
- Views: 6694
- Tue Mar 16, 2010 8:38 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Need Help about SYNCTOOL
- Replies: 12
- Views: 25815
Thank you skolusu for your quick answer, but i didnt succeed to adapt your sample to my real script. i gave you wrong informations because i thought it was easier to understand for you and also for me. the real files are FB LRECL=3941, with an ID of 9 digits. This is the result i got : ABEND=S000 U...
- Mon Mar 15, 2010 9:03 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Need Help about SYNCTOOL
- Replies: 12
- Views: 25815
zouzoucoiffure, The following DFSORT JCL will give you the desired results. Since both files are of the same lrecl and recfm we concatenate them with a header record $$$ which will differentiate the records from each file. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * $$$ // DD DSN=You...
- Thu Mar 11, 2010 9:44 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sorting groups with several headers
- Replies: 1
- Views: 3852
Martin.G,
Look at the smart DFSORT Trick "Sort groups of records" here
http://www.ibm.com/support/docview.wss? ... g3T7000094
Look at the smart DFSORT Trick "Sort groups of records" here
http://www.ibm.com/support/docview.wss? ... g3T7000094
- Thu Feb 25, 2010 10:55 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Two different record length files
- Replies: 5
- Views: 11713
I have to do this in a single step of SORT. I don't understand the fascination for doing everything in a single step which in this case can turn out to be quite inefficient. Even though it is a single step , it would actually require 3 passes of data to get the desired results. But using 2 steps it...