NOT COLUMN OF INSERTED/UPDATED TABLE
Posted: Fri Apr 01, 2005 12:47 pm
Hi all,
My target database is DB2, I have two key columns which have to be loaded into target, but when I run the job there is a warning NOT COLUMN OF INSERTED/UPDATED TABLE, OR ANY TABLE IN A FROM CLAUSE but whereas when I load it into sequential file there is no error.
And when I load into DB2 by removing one column as key, then it loads.
But I want all the rows with both columns as keys(composite).
Can anybody help me please....
Thanks in advance.
Sai.
My target database is DB2, I have two key columns which have to be loaded into target, but when I run the job there is a warning NOT COLUMN OF INSERTED/UPDATED TABLE, OR ANY TABLE IN A FROM CLAUSE but whereas when I load it into sequential file there is no error.
And when I load into DB2 by removing one column as key, then it loads.
But I want all the rows with both columns as keys(composite).
Can anybody help me please....
Thanks in advance.
Sai.