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
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.