Lu, Huayi 27019c2991 DWS TOOL 830.201 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:35:25 +00:00

4.6 KiB

Raw Permalink Blame History

SET

SET is a unique feature in Teradata. It does not allow duplicate records. It is addressed using the MINUS set operator. Migration tool supports MULTISET and SET tables. SET table can be used with VOLATILE.

Input: SET TABLE

1
2
3
4
5
CREATE SET VOLATILE TABLE tab1 ... ;
INSERT INTO tab1
SELECT expr1, expr2, ...
FROM tab1, ...
WHERE .... ;

Output

1
2
3
4
5
6
7
CREATE LOCAL TEMPORARY TABLE tab1 
... ; INSERT INTO tab1
SELECT expr1, expr2, ...
FROM tab1, ...
WHERE ....
MINUS 
SELECT * FROM tab1 ;

Parent topic: Migrating Tables

4.6 KiB Raw Permalink Blame History

SET

4.6 KiB

Raw Permalink Blame History