Search found 25 matches
- Fri Apr 16, 2010 1:46 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Need Help about SYNCTOOL
- Replies: 12
- Views: 25814
- Fri Apr 16, 2010 1:40 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Join through splice
- Replies: 2
- Views: 8675
Here is a sample SORT job that may give you the desired results: //SORT1 EXEC PGM=SORT //SORTJNF1 DD * 1111 PARDEEP 2222 MITTAL 3333 NAVEEN 4444 SACHIN 6666 RAHUL //SORTJNF2 DD * 1111 ABCD 2222 XYZ 2222 KSDF 3333 KSDFJH 5555 TESTONE //SORTOUT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSIN DD * JOINKEYS FI...
- Tue Feb 23, 2010 8:43 pm
- Forum: JCL
- Topic: Need to compare two files using sort in jcl
- Replies: 2
- Views: 17899
Based on the information provided, here is a SyncSort for z/OS job that will do what you asked: //STEP1 EXEC PGM=SORT //SORTJNF1 DD * 1 SDBSKAFJO 456 12 12302009 NEJFIREJT 2 NARJWEOP 678 DFNGIJREO //SORTJNF2 DD * 3 NWERJIEO 456 12 12302009 EITJERTRRO 4 SFEIJWERF 678 34 10202009 NKEWREWE //SORTOUT DD...
- Thu Dec 31, 2009 12:27 am
- Forum: JCL
- Topic: Compare 2 files, excluding one fields from both.
- Replies: 6
- Views: 15149
Here is a SyncSort for z/OS JOIN application that will produce the requested output: //SORT1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTJNF1 DD * AAAABBBB2222CCCC4444... CCCCXXXX1111DDDD5555... EEEEFFFF4444XXXXYYYY... //SORTJNF2 DD * AAAABBBB3333CCCC4444... CCCCXXXX0000DDDD5555... EEEEFFFF44442222AAAA...
- Tue Dec 15, 2009 1:26 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Equalent SYNCSORT commands for DFSORT commands
- Replies: 1
- Views: 4678
- Mon Oct 26, 2009 10:07 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Getting insufficient space - SYNCSORT
- Replies: 6
- Views: 12793
uthami,
Please send me the complete job listing, including the JES Job Log, JCL and SYSOUT messages, and I would be happy to review it for you and make any necessary recommendations. You can forward that output as a text attachment to alissa.margulies@syncsort.com.
Regards,
Please send me the complete job listing, including the JES Job Log, JCL and SYSOUT messages, and I would be happy to review it for you and make any necessary recommendations. You can forward that output as a text attachment to alissa.margulies@syncsort.com.
Regards,
- Mon Oct 26, 2009 9:53 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Eliminate duplicate records in file
- Replies: 8
- Views: 23136
...dont we have any other means with normal SORT/SYNCSORT, because none of the jobs in our system uses ICETOOL. SyncSort ships with ICETOOL as an alias to SYNCTOOL. If you prefer, as Frank suggested, you can code the following SyncSort job: //STEP1 EXEC PGM=SORT //SORTIN DD DSN=input.file //SORTOUT...
- Tue Sep 29, 2009 2:57 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Syncsort 1.3.2 question
- Replies: 6
- Views: 13482
Yes, feel free to contact me offline at alissa.margulies@syncsort.com. Please include the complete and unedited job listing, including the JES job log, JCL and SYSOUT messages as a text attachment and I would be happy to further assist you.
Regards,
Regards,
- Tue Sep 29, 2009 2:54 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort on date
- Replies: 6
- Views: 11389
- Tue Sep 29, 2009 2:50 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - COUNT
- Replies: 10
- Views: 18227
- Tue Aug 04, 2009 11:02 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: On Syncsort
- Replies: 2
- Views: 7551
Here is another alternative.
Code: Select all
//S1 EXEC PGM=SORT,PARM='VLTESTI=2'
- Fri Jul 10, 2009 1:21 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SPLICE! - Help needed (urgent)
- Replies: 6
- Views: 11537
- Tue Jul 07, 2009 2:10 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Select records based on some condition
- Replies: 7
- Views: 10652
- Thu Jun 18, 2009 8:15 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Count the records and print at end.
- Replies: 7
- Views: 12655
- Wed Jun 17, 2009 7:38 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Count the records and print at end.
- Replies: 7
- Views: 12655
Are the HEADER and TRAILER records already part of the data set? If so, here is a SyncSort for z/OS job that will produce the record count: //SORT1 EXEC PGM=SORT //SORTOUT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SORTIN DD * HTEST 123968711BM 234968711CM 234968896BM 567968858DM 567968889AM TRILER //SYSIN ...