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..
Teradata unique secondary index error
Moderators: chulett, rschirm, roy
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:
In the after section:
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;
Code: Select all
create unique index (field1, field2) on mydb.mytable;
-- or --
create unique index myindxname (field1, field2) on mydb.mytable;