Teradata unique secondary index error

[vans2003]

I have table with Secondary indexes on severl columns in Teradata
so when I try to load data using Multiload Plugin I am getting the following error...

09:04:39 UTY0805 RDBMS failure, 3547: MLoad target table may not contain unique secondary
indexes.

it means I can't load data with secondary indexes..what I need here is..
droping secondary indexes before loding and recreating after loading....
need some kind of BTEQ script or................

any help would be appreciated.........

Thanks,
Vans..

[bcarlson]

You can use the before/after sections of the Multiload stage.

Syntax depends on if you have named indexes or not. I'll use both types in the example:

In the before section:

Code: Select all

drop unique index (field1, field2) on mydb.mytable;
-- or --
drop unique index myindxname on mydb.mytable;

In the after section:

Code: Select all

create unique index (field1, field2) on mydb.mytable;
-- or --
create unique index myindxname (field1, field2) on mydb.mytable;