Specifies the type of temporary tables and table storage when the engine creates tables in SAP HANA.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Restrictions: | If you do not specify a value for this option, tables that are created in SAP HANA follow the SAP HANA default for row or column store. |
| ROW and COLUMN are mutually exclusive. | |
| LOCAL and GLOBAL are mutually exclusive. | |
| Do not specify LOCAL or GLOBAL for permanent tables. | |
| Interaction: | The TABLE_TYPE data set option overrides the TABLE_TYPE LIBNAME option. |
| Data source: | SAP HANA |
| See: | CONNECTION= (for sharing sessions across librefs), TABLE_TYPE= data set option |
| Examples: | TABLE_TYPE=ROW |
| TABLE_TYPE=COLUMN | |
| TABLE_TYPE=LOCAL | |
| TABLE_TYPE=GLOBAL | |
| TABLE_TYPE=(COLUMN GLOBAL) |
Table of Contents
creates a table using ROW-based storage in SAP HANA.
creates a table using COLUMN-based storage in SAP HANA.
creates a local temporary table in SAP HANA. The table definition and data are visible only in the current session.
Alias: LOCAL TEMPORARY
creates a global temporary table in SAP HANA. The global temporary tables are globally available, and the data is visible only in the current session.
Alias: GLOBAL TEMPORARY
This option takes effect when a SAS program creates a table in SAP HANA.
When more than one argument is specified, place the arguments within parentheses () and separate them with a space.