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
 

 

Need a SYNCSORT Technique

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

New User


Joined: 28 Nov 2007
Posts: 64
Location: Chennai

PostPosted: Mon Feb 09, 2009 3:40 pm    Post subject: Need a SYNCSORT Technique
Reply with quote

Hi all,

I faced a new Problem so Could you guys please help me out.

I have an input file ( Named FILE1 ) where the LRECL = 200 and it has data Upto 190 and the Rest 10 fields are Spaces. The fields are separated by ";".

In the File1 I have a field whose length = x(6) which actully starts after 4 semicolons. So there is no fixed position of the field. Please find below the Sample Input File.

Code:

----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
111;123456789012;111111111;000000;sanjeet;102;sa;
222;;;333333333;222222;Sambhu;123;sa;
333;;;555555555;444444;Saam,1025;;   
444;456789012345;444444444;333333;Sampath;20;mp;
555;234567890123;222222222;111111;Sankar;101;ra;



I have one more file ( Named FILE2 ) whose LRECL = 80. That contains only two fields which has been separated by ";".

Code:

----+----1----+----2----+----3----+----4----+----5----+----6----+----7
111111111;123456789
444444444;456789012
222222222;234567890
555555555;567890123
333333333;345678901



So I need to replace the X(06) field with the new value i.e x(09) when the value present after the three ";" in FILE1 = The first field of File2.
After replacing with the length=6 to length=9 the remaining fields should come as it is .

So the output need to come as follows,


Code:

----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
111;123456789012;111111111;123456789;sanjeet;102;sa;
222;;;333333333;345678901;Sambhu;123;sa;
333;;;555555555;567890123;Saam,1025;;   
444;456789012345;444444444;456789012;Sampath;20;mp;
555;234567890123;222222222;234567890;Sankar;101;ra;



Moreover the FILE1 Contains one HEADER RECORD and two TRAILER. That is not present in FILE2 but the resultant output should contain the Header and Trailer.
Back to top
View user's profile Send private message

siva102

New User


Joined: 28 Nov 2007
Posts: 64
Location: Chennai

PostPosted: Tue Feb 10, 2009 11:54 am    Post subject:
Reply with quote

Hi all,

Can it be done by any other means ???
Like by using the ICETOOL ???
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Tue Feb 10, 2009 12:45 pm    Post subject:
Reply with quote

Siva,

Which version of SyncSort are you running?
Back to top
View user's profile Send private message
siva102

New User


Joined: 28 Nov 2007
Posts: 64
Location: Chennai

PostPosted: Tue Feb 10, 2009 2:31 pm    Post subject:
Reply with quote

Hi Arun,

Neither I am having any Idea about that nor i know hw to check ???


If Possible please guide me hw to chk that.
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Tue Feb 10, 2009 3:17 pm    Post subject:
Reply with quote

Hi Siva,

You can see at first line like below when you open SYSOUT of your SORT step.
Code:
SYNCSORT FOR Z/OS  2.3.1.0NI

In that, if you see WER messages, you've SYNCSORT installed in.
Or if messages are with ICE, DFSORT is installed in.
Back to top
View user's profile Send private message
siva102

New User


Joined: 28 Nov 2007
Posts: 64
Location: Chennai

PostPosted: Tue Feb 10, 2009 3:40 pm    Post subject:
Reply with quote

Hi Gnanas,

Thanks for the Info.

My system is having Syncsort.

Code:

SYNCSORT FOR Z/OS  1.3.1.0N
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Tue Feb 10, 2009 8:17 pm    Post subject:
Reply with quote

Siva,

I believe it's possible using a PARSE/JOIN application. I am back at my SyncSort 1.2 shop; so I cant run a test now.icon_sad.gif

1. PARSE the fields by ';' to bring the fields to fixed positions
2. JOIN the above file to your second file to replace the values.
3. Left justify the resultant file after inserting back the ';'.
Back to top
View user's profile Send private message
siva102

New User


Joined: 28 Nov 2007
Posts: 64
Location: Chennai

PostPosted: Wed Feb 11, 2009 9:31 am    Post subject:
Reply with quote

Hi Arun,

Thanks for the idea that u gave.

I ll go through the SYNCSORT document and ll try to get the output as u adviced.
Back to top
View user's profile Send private message
Brian Wood

New User


Joined: 12 Feb 2009
Posts: 2
Location: United States

PostPosted: Fri Feb 13, 2009 1:48 am    Post subject: Reply to: Need a SYNCSORT Technique
Reply with quote

Siva: If you require further assistance with this, please contact me at zos_tech@syncsort.com.
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 5 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