Oracle table is not getting updated
Posted: Fri Jan 16, 2009 5:12 am
I'm loading a table with source as sequential file using upsert method.
My job design is:
sequential file --> transformer ---> oracle table.
At source i have 3 columns say col1 int,col2 char,col3 varchar.
At target i have 4 columns say col1 int,col2 char,col3 varchar,col4 timestamp.
primary key: col1(int) and col2(char)
Using tranformer i'm assigning the value "current timestamp" to col4.
At target i used upsert method, when i have a new record it's inserting properly but when i have an update all the updated records are going to reject link and the sqlcode it's given as "1403"(update not found).
if i change the datatype of col2 which is one of my key columns as integer then the records are getting updated.
Did the composite primary key of "int" and "char " combination wouldn't update the records?
DS gurus please help me out...
Any help will be appreciated greatly..
My job design is:
sequential file --> transformer ---> oracle table.
At source i have 3 columns say col1 int,col2 char,col3 varchar.
At target i have 4 columns say col1 int,col2 char,col3 varchar,col4 timestamp.
primary key: col1(int) and col2(char)
Using tranformer i'm assigning the value "current timestamp" to col4.
At target i used upsert method, when i have a new record it's inserting properly but when i have an update all the updated records are going to reject link and the sqlcode it's given as "1403"(update not found).
if i change the datatype of col2 which is one of my key columns as integer then the records are getting updated.
Did the composite primary key of "int" and "char " combination wouldn't update the records?
DS gurus please help me out...
Any help will be appreciated greatly..