![]() |
If i use SET table then the Teradata database will perform duplicate search in that table while loading the data. Am i correct?
20 Nov 2012
| 8 comments
,
|
![]() |
I want to copy structure of a SET table to a New table as MULTISET. Is there any way we can do this?
I want to copy structure of a SET table to a New table as MULTISET. Is there any way we can do this?
29 Dec 2011
| 2 comments
,
|
![]() |
Hi, Is there is a way to alter a set table to multiset apart from drop re-create table..?
06 Dec 2011
| 3 comments
,
|
![]() |
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.
11 Nov 2011
| 1 comment
,
|
![]() |
SET dyn_sql = SET 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.
15 Jul 2010
,
|