MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 120 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Adding keys to records using Syncsort
amargulies

Replies: 2
Views: 1944

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PostForum: 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= ...
 
Page 1 of 8 Goto page 1, 2, 3, 4, 5, 6, 7, 8  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group