DSXchange

keshav0307 wrote:do you have unique index on the key columns?

No there is no index for the key columns. & i dont have access to do it.

vaidehee - in that case I would assume that it does an insert then update and since you don't have a unique key the insert is always successful. How about doing "user-defined insert and update" and th ... same thing is happen with user-defined insert & update..It still only inserting ...

Specify the "key" column (which then moves into the WHERE clause of the UPDATE statement). In this context "key" does not necessarily mean "primary key". Note, however, that if there is no primary k ... Yes i have mentioned key columns in WHERE clause of query.. but st...

You are probably doing an insert-then-update instead of update-then-insert. ... In DB2/UDB Enterprise stage its having Upsert mode as "Auto generated Update & Insert " So i think it will consider update first.. & in update query we are mentioning columns in where clause on which w...

You are probably doing an insert-then-update instead of update-then-insert. ... In DB2/UDB Enterprise stage its having Upsert mode as "Auto generated Update & Insert " So i think it will consider update first.. & in update query we are mentioning columns in where clause on which w...

Hi all, i am using DB2/UDB Enterprise stage for target table,i mentioned 4 key columns for the table. At db2 level i dont have any key columns for this table. I want to insert the record if it doesnt exist & update record if its not present. For new record it works fine. But when i got record wh...

I have developed one job Its having Table_1 as target table.For target stage i am using Db2 partition(Db2/UDB Enterprise stage). Its showing me error like "main_program: Fatal Error: Table `Table_1' must exist before querying the node group" This table is having partition as follows: CREAT...