i have table with all datatype as varchar (100) ,i want to update the table by using txt file.i have defined all columns as * varchar (100) in Mload script.when iam trying to load data it is moving into UV table.
Note:iam updating on index column.
can you please let me know why it is moving. as i dont have duplicate data.
update statement in script.
Applyseq SourSeq uniqness DBCERROR
1 589 0 2797
1 2683 0 2797
1 2108 0 2797
1 1874 0 2797
Apply trim and try to select particular record. If you're select is successful then you can apply the same to update also
sel * from table_name where empid = trim('1234');
The DBCErrorCode (MLoad MARK MISSING UPDATE) indicates that the target row was not found.
If this is your actual WHERE-condition you compare to the literal string ':empid', change it to WHERE empid=:empid;