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
 

 

Can SYNCSORT do this ?

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

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Mon May 18, 2009 4:45 am    Post subject: Can SYNCSORT do this ?
Reply with quote

Hello,

I have have got a input file which looks like below :

Code:
----+----1----+----2----+----3----+----4----+----5
             |STEVE       |A4A 1A4     --> A
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
4.1          |STEVE       |A4A 1A4   
             |STEVE       |A0A 1A0      --> B


Please note the records A & B in the above layout. What this dipicts is :
All the records between A & B are under record A ( lets call it A's subsets ). '4.1' in column 1 tell me that these are subsets.

However there could no records under A. In that case my input file would look like

Code:
----+----1----+----2----+----3----+----4----+----5
             |STEVE       |A4A 1A4    --> A
             |STEVE       |A0A 1A0    --> B


The requirement here is, if there is no A's subsets, then I dont want to show A ( I would like to show B though ) in the output file.

Any advises would be appreciated.

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

Arun Raj

Moderator


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

PostPosted: Mon May 18, 2009 7:40 am    Post subject:
Reply with quote

ap_mainframes,

1) Do you have multiple sets of "A" records in input?
2) Can a group header can be identified by a "-->" at pos-40?
3) Your sample data shows the same values at pos-28 thru pos-34 for a group (A and its subset records). Will this be true for all the groups?
4) Which SyncSort version are you using?

Please post some sample data good enough to cover all possible cases, input/output LRECL/RECFM etc.
Back to top
View user's profile Send private message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Mon May 18, 2009 8:29 am    Post subject:
Reply with quote

Arcvns,

Answeres to your questions :

1. Yes, I do have multiple sets of "A" records.

2. No, I gave "-->" just for the sake of understanding. The only thing that identifies that its a group header is the fact that there is nothing ( like 4.1 ) in column 1.

3. Yes, this'll be true for all records.

4. Unfortunately, I am not sure of that. How can I find it out ?
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Mon May 18, 2009 8:46 am    Post subject:
Reply with quote

ap_mainframes,
A more meanful topic would have made it easier for others who are searching topics here.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 18, 2009 9:01 am    Post subject:
Reply with quote

Hello,

Quote:
4. Unfortunately, I am not sure of that. How can I find it out ?
Run a sort and the version info will be printed on the informational output.
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Mon May 18, 2009 9:51 am    Post subject:
Reply with quote

ap_mainframes wrote:
No, I gave "-->" just for the sake of understanding. The only thing that identifies that its a group header is the fact that there is nothing ( like 4.1 ) in column 1
From what you said above, I guess a group header can be identified by a "space" at pos-1. Then how do you differentiate an "A" group from a "B" group?
What about RECFM/LRECL?
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 SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am


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