Author |
Message |
Topic: Adding keys to records using Syncsort |
amargulies
Replies: 2
Views: 1944
|
Forum: Utilities Posted: Mon Aug 03, 2009 11:01 am Subject: Adding keys to records using Syncsort |
rajeshkoratti,
This can be accomplished in SyncSort for z/OS 1.3 using WHEN=GROUP. This is a free upgrade from release 1.2. I would recommend contacting your system programmer to request the curr ... |
Topic: FileA and FileB matching records problem..... |
amargulies
Replies: 5
Views: 3504
|
Forum: Utilities Posted: Tue Jun 23, 2009 10:03 am Subject: FileA and FileB matching records problem..... |
computer,
Here is a SyncSort for z/OS job that will produce the requested records:
//STEP1 EXEC PGM=SORT
//SORTJNF1 DD *
12345
2 ... |
Topic: sort performance |
amargulies
Replies: 1
Views: 1688
|
Forum: Utilities Posted: Mon Jun 15, 2009 9:58 am Subject: sort performance |
Which SORT utility and version are you running? |
Topic: To identify duplicate records in a file |
amargulies
Replies: 4
Views: 12495
|
Forum: Utilities Posted: Thu Jun 04, 2009 9:54 am Subject: To identify duplicate records in a file |
kanitha-mvs,
Using SyncSort for z/OS, records removed by SUM processing can be written to a separate data set defined by the SORTXSUM DD statement as follows:
//STEP1 EXEC PGM=SORT
//SYSOUT DD ... |
Topic: Syncsort: Trailer count validation |
amargulies
Replies: 3
Views: 6043
|
Forum: Utilities Posted: Tue May 19, 2009 10:01 am Subject: Syncsort: Trailer count validation |
Phantom,
I have run several tests and have come to the conclusion that I do not believe that this can be accomplished in a single step.
Regards, |
Topic: Vertical To Horizontal , Can it be possible by SyncSort |
amargulies
Replies: 8
Views: 8677
|
Forum: Utilities Posted: Fri May 15, 2009 1:02 pm Subject: Vertical To Horizontal , Can it be possible by SyncSort |
Manoj,
The IFTHEN/BUILD statements are reformatting the records with embedded binary zeros at various positions dependant upon the SEQNUM value.
(In order to see exactly what is being done here, ... |
Topic: Vertical To Horizontal , Can it be possible by SyncSort |
amargulies
Replies: 8
Views: 8677
|
Forum: Utilities Posted: Thu May 14, 2009 10:01 am Subject: Vertical To Horizontal , Can it be possible by SyncSort |
Martin,
Here are 2 examples related to what the OP was asking for. Please note, both examples require SyncSort for z/OS 1.2.1 or later.
EXAMPLE 1:
//SORT1 EXEC PGM=SORT,PARM='EQUALS' ... |
Topic: Syncsort: Trailer count validation |
amargulies
Replies: 3
Views: 6043
|
Forum: Utilities Posted: Mon May 11, 2009 3:48 pm Subject: Re: Syncsort: Trailer count validation |
I'll get back to you on this. |
Topic: Formatting the record |
amargulies
Replies: 2
Views: 1882
|
Forum: Utilities Posted: Mon Apr 20, 2009 2:16 pm Subject: Formatting the record |
Try this SyncSort for z/OS 1.3 application:
//SORT EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTOUT DD SYSOUT=*
//SORTIN DD * ... |
Topic: S0C4 abend in SYNCSORT |
amargulies
Replies: 9
Views: 13229
|
Forum: Utilities Posted: Thu Apr 02, 2009 1:46 pm Subject: S0C4 abend in SYNCSORT |
vak255,
If you are running SyncSort for z/OS, and a dump was produced when you originally got the Abend 0C4, feel free to send it to me offline at alissa.margulies@syncsort.com and I would be happy ... |
Topic: Report from a Report |
amargulies
Replies: 6
Views: 3359
|
Forum: Utilities Posted: Fri Mar 13, 2009 9:33 am Subject: Report from a Report |
TVSSV,
Support for WHEN=GROUP was included in SyncSort for z/OS 1.3.2.0. You are getting the syntax error because you are running an earlier release of the product which does not support this feat ... |
Topic: Merging files columnwise |
amargulies
Replies: 2
Views: 3607
|
Forum: Utilities Posted: Thu Mar 12, 2009 10:19 am Subject: Merging files columnwise |
Sebastian,
Here is a SyncSort for z/OS application that will produce your desired results:
//STEP1 EXEC PGM=SORT
//SORTJNF1 DD *
123A ... |
Topic: Report from a Report |
amargulies
Replies: 6
Views: 3359
|
Forum: Utilities Posted: Thu Mar 12, 2009 10:10 am Subject: Report from a Report |
Assuming that your records were wrapped in the above example, and that your input file is really FB/133, the following SORT step should produce your desired results:
//STEP1 EXEC PGM=SORT
//SYSOUT ... |
Topic: Is sorting and filtering of records with SYNCSORT possible? |
amargulies
Replies: 5
Views: 4079
|
Forum: Utilities Posted: Fri Feb 27, 2009 11:25 am Subject: Is sorting and filtering of records with SYNCSORT possible? |
Hello retep baar and welcome to the Forum.
Just to clarify, you want 2 separate output files, correct?
In the first step, why are you coding an include statement if you want all the records? Wi ... |
Topic: Specific records to be sorted |
amargulies
Replies: 2
Views: 1867
|
Forum: Utilities Posted: Thu Feb 26, 2009 10:18 am Subject: Specific records to be sorted |
Assuming the input file is FB/80, try this alternate solution:
//S1 EXEC PGM=SORT
//SORTIN DD DSN=input.file,...
//SORTOUT DD DSN=output.file,...
//SYSOUT DD SYSOUT= ... |
|