Specifies the type of temporary tables and table storage when the engine creates tables in SAP HANA.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Access |
| 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 | LOCAL TEMPORARY and GLOBAL | GLOBAL TEMPORARY are mutually exclusive. | |
| Do not specify LOCAL | LOCAL TEMPORARY or GLOBAL | GLOBAL TEMPORARY 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= LIBNAME 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.
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.
This option takes effect when a SAS program creates a table in SAP HANA.