Search found 25 matches

by Alissa Margulies
Fri Apr 16, 2010 1:46 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need Help about SYNCTOOL
Replies: 12
Views: 25814

The files will get sorted during JOIN processing. Since you are not changing the sort order, you can code SORT FIELDS=COPY.
by Alissa Margulies
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...
by Alissa Margulies
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...
by Alissa Margulies
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...
by Alissa Margulies
Tue Dec 15, 2009 1:26 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Equalent SYNCSORT commands for DFSORT commands
Replies: 1
Views: 4678

In the first case, FINDREP is supported in SyncSort for z/OS 1.3.2.

In your second case, what error are you getting?
by Alissa Margulies
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,
by Alissa Margulies
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...
by Alissa Margulies
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,
by Alissa Margulies
Tue Sep 29, 2009 2:54 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort on date
Replies: 6
Views: 11389

SyncSort does not currently have the facility to perform arithmetic on date/time fields. I cannot answer for DFSORT.
by Alissa Margulies
Tue Sep 29, 2009 2:50 am
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT - COUNT
Replies: 10
Views: 18227

SyncSort for z/OS 1.2.3.1 ships with SYNCTOOL release 1.5. You need to upgrade to SyncSort for z/OS 1.3.2 in order to support the DATASORT function in SYNCTOOL.
by Alissa Margulies
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'
by Alissa Margulies
Fri Jul 10, 2009 1:21 am
Forum: DFSORT , ICETOOL & Utilities
Topic: SPLICE! - Help needed (urgent)
Replies: 6
Views: 11537

M11 is an Edit Mask, which specifies that all digits are significant with no leading or trailing signs.
by Alissa Margulies
Tue Jul 07, 2009 2:10 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Select records based on some condition
Replies: 7
Views: 10652

Bathri,

Support for WHEN=GROUP was included in SyncSort for z/OS 1.3.2. Since you are running an earlier release, I would recommend referring to the alternate solution posted by arcvns.
by Alissa Margulies
Thu Jun 18, 2009 8:15 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Count the records and print at end.
Replies: 7
Views: 12655

One alternative is to print the leading zeros: //SYSIN DD * OMIT COND=(1,1,CH,EQ,C'T') SORT FIELDS=COPY OUTFIL FILES=OUT, TRAILER1=(1:C'T', COUNT-1=(EDIT=(TTTTTTT))),REMOVECC /* Producing these results: HTEST 123968711BM 234968711CM 234968896BM 567968858DM 567968889AM...
by Alissa Margulies
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 ...