Allows additional database-specific options to be placed after the CREATE TABLE statement in generated SQL code.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Alias: | DBCREATE_TABLE_OPTS= |
| Default: | none |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, Hadoop, HAWQ, Impala, Informix, JDBC, Microsoft SQL Server, Netezza, Oracle, PostgreSQL, SAP ASE, SAP IQ, Snowflake, Teradata, Vertica |
| See: | DBCREATE_TABLE_OPTS= LIBNAME option, DBIDIRECTEXEC system option, POST_STMT_OPTS= data set option |
Table of Contents
specifies database-specific options to be placed after the CREATE TABLE statement. Enclose the options that you specify within single or double quotation marks.
You can use POST_STMT_OPTS= to add DBMS-specific clauses to the end of the SQL CREATE TABLE statement. The SAS/ACCESS engine passes the SQL CREATE TABLE statement and its clauses to the DBMS, which executes the statement and creates the DBMS table. POST_STMT_OPTS= applies only when you are creating a DBMS table by specifying a libref that is associated with DBMS data.