MLOAD UPDATE Help

Tools & Utilities
Enthusiast

MLOAD UPDATE Help

Hello Friends,

I am a very newbie to Teradata...

To do MLOAD update...this is my understanding...

We will have to have all the columns in PI in the where clause of update statement and we can not update the columns(Update set col1 = :col2 if col1 is part of PI).

Please correct me if i am wrong.

If we have partitioned by date column which is not part of PI should we follow the same quidelines as above.

Any help is appreciated...

Thanks In Advance!