If i use SET table then the Teradata database will perform duplicate search in that table while loading the data.
When i use UPI, it eliminates duplication search.

Am i correct?
Could some one please explain in detail?

I want to copy structure of a SET table to a New table as MULTISET. Is there any way we can do this? 

Hi,

Is there is a way to alter a set table to multiset apart from drop re-create table..?

table1 ia a multiset table.Using table1 , 2 tables are created using the following syntax:

1- CT table2 as (select * from table1) with no data;

2- CT table3 as table1 with no data;

table2 is SET table , while table3 is MULTISET table.

SET dyn_sql =
'Select TableName into hTableName from ' || TRIM(i_FullWorkTableName) ||
';'
;
call dbc. SysExecSQL(:dyn_sql)
;

SET dyn_sql =
'call sysdba.spETL_Table_' || hTableName|| '(:i_FullStageTableName);'
;
call dbc. SysExecSQL(:dyn_sql)
;

I get this when above is called. compiles correctly.

5568 SQL statement is not supported within a stored procedure.

What I am trying to do is call a stored procedure to work on specific table. I can get table name as an input parameter or sel from a table.
call spetl_a
call spetl_b
call spetl_c