All Forums Database
Sram 21 posts Joined 03/16
04 Apr 2016
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.

sakthikrr 53 posts Joined 07/12
04 Apr 2016

Please share some samples and logs.

Sakthi

Sram 21 posts Joined 03/16
04 Apr 2016

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
 

Sram 21 posts Joined 03/16
04 Apr 2016

do we need to wirte trim function in filter condition?

sakthikrr 53 posts Joined 07/12
04 Apr 2016

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

 

Sakthi

dnoeth 4628 posts Joined 11/04
04 Apr 2016

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;

Dieter

sakthikrr 53 posts Joined 07/12
04 Apr 2016

Thanks Dieter!!

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

 

Sakthi

Sram 21 posts Joined 03/16
05 Apr 2016

Thanks Dieter,Sakthi

You must sign in to leave a comment.