|
|
Archives of the TeradataForum
Message Posted: Wed, 17 Jun 2009 @ 19:41:39 GMT
Subj: | | Re: Doubts Regarding TD Utilities |
|
From: | | Michael Larkins |
| I think you've maybe mis-read #2. Multiload has never been able to load a table which has USI's defined to it. A job against a table with a
USI fails with "3547: MLoad target table may not contain unique secondary indexes" | |
Thanks Dave: you are absolute correct. I read UPI instead of USI - duh. A USI has the possibility of being located on a different AMP
which dis-allows its creation or modification via MLOAD. That is what I get for trying to help during a chemo treatment. Sorry and thanks for
the kindness of your reply.
Mike
| |