Can this be done using SYNCTOOL

shrinivasabharathi_b · New User Joined: 04 Nov 2008 Posts: 11 Location: Chennai

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?

Arun Raj · Posted: Fri Dec 12, 2008 6:55 pm

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)

shrinivasabharathi_b · New User Joined: 04 Nov 2008 Posts: 11 Location: Chennai

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

Arun Raj · Posted: Fri Dec 12, 2008 7:46 pm

shrinivasabharathi_b,

Arun Raj · Posted: Fri Dec 12, 2008 8:57 pm

shrinivasabharathi_b,

Another method is to write the DATE and TIME values to a parm dataset as

shrinivasabharathi_b · New User Joined: 04 Nov 2008 Posts: 11 Location: Chennai

Thank U ..will give a try

Arun Raj · Posted: Sat Dec 13, 2008 12:33 am

shrinivasabharathi_b,

Good luck, Reply here if you face any issues.

I just noticed that the date format I mentioned in my previous post is not correct; the correct one would be