Hi,
I am loading data in db2 database using datastage.
In the process of loading I have two processing columns
add date, Modified date.
I am Using db2 stage to load data.
Job design is like \
Source -----> Tfm--------> Target.
Using update action : update existing or Insert New rows.
we are passing the values to adddate,modified date manually (hardcoded) in the transformer stage.
when I ran my job data is moving fine but for both update and Insert both date fields are populating
My requirement is I need pass both the date columns to Newly Inserted records only. For updated records I have to papulate only modified date .
Please suggest me how to achive this in datastage.
I appriciate your time and help.
Thanks
VKR
Issue with db2 update&Insert Statement
Moderators: chulett, rschirm, roy