Hi,

I want to load the TRASACTION table with the updated values of DT_A and DT_B with input file.

While loading i want to update the values of DT_A and DT_B by 7 days.
Data type of DT_A is smallint and DT_B is date.

How to achieve this?

If there is no other solution to do this in load phase and if you know JCL SORT
through which we can achieve this?

Thanks-
Denis.

How about update after loading ... using UPDATE SQL statement (since we know exactly by how much we have to adjust values in these columns)

How about modifying the input file during export of that file and specifying the values during export itself. So your EXPORT will be something like
The only problem here is whether you'll be able to get the input file in that format.