Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Syncsort version problem

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Fri Jan 30, 2009 12:28 pm    Post subject: Syncsort version problem
Reply with quote

Hi ALl.

We are upgrading to Syncsort v1.3 and were doing a few regressions to check output.
The sort card we are using is :
INREC FIELDS=(1:48,1,
2:56,4,
6:60,3,
9:271,2,
11:304,2,
13:49,1,
14:54,1,
15:X'0000001F',
19:18,3,
22:67,3,
25:327,1,
26:258,5,
31:282,6,
37:328,1)
SORT FIELDS=(1,1,CH,A,
2,4,CH,A,
6,3,CH,A,
9,2,CH,A,
11,2,CH,A,
13,1,CH,A,
19,3,CH,A,
14,1,CH,A)
SUM FIELDS=(15,4,PD,26,5,PD)


I noticed for the same sort card the different versions of syncsort are giving different values in the position 31-36. Please have a look at the card and help me in knowing why this is happening.

Thanks, cics guy
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Fri Jan 30, 2009 1:03 pm    Post subject:
Reply with quote

CICS fan,

Are you saying that for the same input file and sort cards, you get different outputs? The functions used here are not so complex, and I believe it should work the same way for 1.2 or 1.3.

BTW, What difference are you seeing in the output files? Is it for a single record or all the records? What are the LRECL/RECFMs of input/output?
Back to top
View user's profile Send private message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Fri Jan 30, 2009 1:07 pm    Post subject:
Reply with quote

input is 400
output is 37
there are some records which are having difference in the position 31-36
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Fri Jan 30, 2009 1:20 pm    Post subject:
Reply with quote

Quote:
there are some records which are having difference in the position 31-36
How did you come to this conclusion? Do you use some utility to compare the output files? Are the number of output records the same? If yes, can you add the EQUALS parameter to your sort card as shown below, test both the versions and compare the output files again?
Code:
SORT FIELDS=(1,1,CH,A,
2,4,CH,A,
6,3,CH,A,
9,2,CH,A,
11,2,CH,A,
13,1,CH,A,
19,3,CH,A,
14,1,CH,A),EQUALS
Back to top
View user's profile Send private message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Fri Jan 30, 2009 1:31 pm    Post subject:
Reply with quote

Yes!! Its working with EQUALS.
But earlier the prod version used to run without EQUALS.
Can you please explain this? Many thanks ...
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Fri Jan 30, 2009 1:52 pm    Post subject:
Reply with quote

CICS fan,

EQUALS parameter retains the order of equally keyed records in your input file. NOEQUALS which is the default mentions that the order of equally-keyed records can be in any arbitrary order. So please do understand that it's NOT a problem with your SyncSort version. If they chose to go with NOEQUALS, they were not worried about the order of 'equally-keyed' records. Go through the 'EQUALS/NOEQUALS' description in your SyncSort manual if you would like to know more.

SyncSort for z/OS Release 1.3 Manual wrote:
The EQUALS parameter insures that the original order of equal-keyed records is preserved. These records will be in the same order in the output file as they were in the input file. NOEQUALS, the default, specifies that equal-keyed records may not be written in their original input order.
Back to top
View user's profile Send private message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Fri Jan 30, 2009 1:57 pm    Post subject:
Reply with quote

Thanks Arun. Much appreciated....Thanks a lot!!!!!!!
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Fri Jan 30, 2009 2:01 pm    Post subject:
Reply with quote

You're welcome. icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us