UV table

Database
Enthusiast

UV table

Hi ,

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.

7 REPLIES
Enthusiast

Re: UV table

Please share some samples and logs.

Enthusiast

Re: UV table

update statement in script.

UPDATE table_name

SET emp_name=:emp_name

,salary=:salary

WHERE empid=':empid';

Log:

Applyseq SourSeq  uniqness DBCERROR

1  589     0      2797

1  2683  0    2797

1  2108   0     2797

1 1874    0     2797

Enthusiast

Re: UV table

do we need to wirte trim function in filter condition?

Enthusiast

Re: UV table

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');
Junior Contributor

Re: UV table

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;

Enthusiast

Re: UV table

Thanks Dieter!!

UPDATE table_name
SET emp_name=:emp_name
,salary=:salary
WHERE empid=:empid;
Enthusiast

Re: UV table

Thanks Dieter,Sakthi