I have a file with header,trailer and detial record.
I need to change the first three position of these records with different values.
and the syntax am using for this in syncsort is
SORT FIELDS=COPY
OUTREC FIELDS=(1,3,CHANGE=(3,C'xxx',C'yyy',
C'aaa',C'bbb',
C'ccc',C'ddd'),4,157)
Here in header I have XXX which I'm changinf to YYY
and in detail i have AAA which I'm changing to BBB
and in trailer i have ccc and i'm changing that to ddd
I need to add one more condition
where i need to change the 7th position(that field is of length 13)
in my header and trailer to some other value of same length.
I need to include this condition in the same sort card.
Could someone tell me the syntax for that in syncsort.
Note: Any of your DETAIL records containing "POST POSITION" at 7-13 positions would also be converted to "POST ACTIVITY". So make sure you dont have any such record in DETAIL Records before running the query.
To resolve this; what else is there in positions 4-6 in your HEADER & TRAILER records.
I may get a value of 001 or 002 or 003 or 004 in the position 4-6
but i don't want to change that position... would that create any problem...
The condition u gave worked fine...
Thanks a lot....
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
Quote:
I may get a value of 001 or 002 or 003 or 004 in the position 4-6
but i don't want to change that position... would that create any problem...
No that would not create a problem... I asked to make conditions more specific.
Quote:
The condition u gave worked fine...
Thanks a lot....
Thats fine... but did you notice the note made in my earlier reply. If that is not the case, this SORT is perfact, otherwise we may need to update the SORT CARD.