Updating DATE and TIMESTAMP columns in DB2
Posted: Sun Jul 10, 2005 10:40 pm
G'day
A really weird one, this. I have a number of existing DataStage jobs that update a timestamp field in a DB2 database using a simple update statement, e.g.
UPDATE
#DB2#.TABLE
SET
END_TSP = ORCHESTRATE.END_TSP
WHERE
KEY = ORCHESTRATE.KEY
The metadata of the updates is set in a preceeding Transformer stage.
The Transformer and DB2 Update stages in my new job is identical to my existing jobs, but I cannot get the update to occur.
I have used a Lookup stage to confirm that the records I want to update exist in the target and match my data.
The only way I can get the records to update is to delete all metadata related to DATE and TIMESTAMP columns in the update SQL. But then three fairly important columns miss out...
Has anyone had any experience with a problem of this ilk before?
Zac.
A really weird one, this. I have a number of existing DataStage jobs that update a timestamp field in a DB2 database using a simple update statement, e.g.
UPDATE
#DB2#.TABLE
SET
END_TSP = ORCHESTRATE.END_TSP
WHERE
KEY = ORCHESTRATE.KEY
The metadata of the updates is set in a preceeding Transformer stage.
The Transformer and DB2 Update stages in my new job is identical to my existing jobs, but I cannot get the update to occur.
I have used a Lookup stage to confirm that the records I want to update exist in the target and match my data.
The only way I can get the records to update is to delete all metadata related to DATE and TIMESTAMP columns in the update SQL. But then three fairly important columns miss out...
Has anyone had any experience with a problem of this ilk before?
Zac.