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: 19567

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: 6809

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: 12873

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: 11337

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: 3358

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: 9216

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: 14438

...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: 9974

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: 8013

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: 13530

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: 5221

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: 7616

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: 7702

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: 8985

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: 8985

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 ...