I am using SAS in an ETL step, to transfer data from a SAS server to Teradata. In short, this looks like:
CREATE TABLE teradataLibName.newTableName AS
SELECT blah FROM blah;
This works. Now I need to make it a MULTISET table for efficiency purposes. I can not simply write "CREATE MULTISET TABLE" as we would do outside SAS's "proc sql" procedure.
Do you know how I can do it?
If you change session mode to ANSI (instead of Teradata) CREATE TABLE (without MULTISET) will result in a MULTISET TABLE created.
To create any kind of table, you can want follow these 3 strategies,
1.You need to use explicit pass through, if all the tables are in teradata.
2. I think your DBA creates the default to set or multiset and at my client site it is multiset, so someone can talk to him.
3. Create a multiset empty table either in sql assistant/bteq or using explicit pass through and in next step then insert data into the table.