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 this be done using SYNCTOOL

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

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Fri Dec 12, 2008 6:35 pm    Post subject: Can this be done using SYNCTOOL
Reply with quote

My File layouts

File 1
----+----1----+----2----+----3----+----4----+----5----+----6----+--
SORT FIELDS=(51,11,CH,A)
INCLUDE COND=(39,4,PD,GE, ,AND,43,4,PD,GT, ,
AND,438,3,CH,EQ,C'146',AND,717,9,CH,NE,C' ')


File 2

----+----1----+----2----+----3----+----4----+----5----+--
1081211 072412

Required output

SORT FIELDS=(51,11,CH,A)
INCLUDE COND=(39,4,PD,GE,1081211,AND,43,4,PD,GT,072412,
AND,438,3,CH,EQ,C'146',AND,717,9,CH,NE,C' ')


Can this be done using SYNCTOOL?
Back to top
View user's profile Send private message

Arun Raj

Moderator


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

PostPosted: Fri Dec 12, 2008 6:55 pm    Post subject:
Reply with quote

shrinivasabharathi_b

You can do this using a simple SORT-OVERLAY. If the date is in cyymmdd format, you must be having the file-2 date fields like this.( i have added a '0' for date-2)
Code:
----+----1----+----2----+----3----+----4----+----5----+--
1081211 0072412
BTW, how you are generating file-2? is it possible to have 7 digit dates in file-2?
Back to top
View user's profile Send private message
shrinivasabharathi_b

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Fri Dec 12, 2008 7:20 pm    Post subject:
Reply with quote

Sorry , value '1081211' is the only date field and value '072412' is the time field .. and we are getting these values from another file header ..
now the req is to take these values from file 2 and place is it in file 1 dynamic cntl card ..

thanks,
Shrini
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Fri Dec 12, 2008 7:46 pm    Post subject:
Reply with quote

shrinivasabharathi_b,

Quote:
we are getting these values from another file header
I would suggest you have the sort card with enough spaces like this
Code:
SORT FIELDS=(51,11,CH,A)
INCLUDE COND=(39,4,PD,GE,       ,AND,43,4,PD,GT,      ,
AND,438,3,CH,EQ,C'146',AND,717,9,CH,NE,C' ')

and OVERLAY the date and time values to the respective positions while you extract this info from the file.
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Fri Dec 12, 2008 8:57 pm    Post subject:
Reply with quote

shrinivasabharathi_b,

Another method is to write the DATE and TIME values to a parm dataset as
Code:
DATE-1,+cddmmyy
TIME-1,+hhmmss
and use this as your SYMNAMES dataset in the subsequent job which has a sort card like this.
Code:
SORT FIELDS=(51,11,CH,A)
INCLUDE COND=(39,4,PD,GE,DATE-1,AND,43,4,PD,GT,TIME-1,
AND,438,3,CH,EQ,C'146',AND,717,9,CH,NE,C' ')
Back to top
View user's profile Send private message
shrinivasabharathi_b

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Fri Dec 12, 2008 9:18 pm    Post subject:
Reply with quote

Thank U ..will give a try
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Sat Dec 13, 2008 12:33 am    Post subject:
Reply with quote

shrinivasabharathi_b,

Good luck, Reply here if you face any issues. icon_smile.gif

I just noticed that the date format I mentioned in my previous post is not correct; the correct one would be
Code:
DATE-1,+cyymmdd
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 SYNCTOOL better than SYNCSORT? Amit_Singh SYNCSORT 3 Wed Jul 23, 2014 11:06 am
No new posts Can any one give me any sample join s... Sanath sekhar Reddy N SYNCSORT 9 Thu Aug 08, 2013 12:03 pm
No new posts SyncSort/SyncTooL to extract records ... Hariharan BK SYNCSORT 25 Tue Jun 04, 2013 2:42 pm
No new posts Work files with SYNCTOOL mlp JCL & VSAM 3 Wed Oct 05, 2011 11:10 am
No new posts Two copies of a file in a single pass... Raymond Sachs JCL & VSAM 2 Fri Sep 09, 2011 11:36 pm


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