DBCREATE_TABLE_OPTS=

DBCREATE_TABLE_OPTS=

Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.

Default value: none

Syntax
Details

Syntax

DBCREATE_TABLE_OPTS='DBMS-SQL-options'

'DBMS-SQL-clauses': are one or more DBMS-specific clauses that can be appended to the end of an SQL CREATE TABLE statement.

Details

DBCREATE_TABLE_OPTS= enables you 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. DBCREATE_TABLE_OPTS= applies only when you are creating a DBMS table by specifying a libref associated with DBMS data.

In the following example, the DB2 table TEMP is created with the value of the DBCREATE_TABLE_OPTS= option appended to the CREATE TABLE statement.

libname mydblib db2 user=testuser
       pwd=testpass dsn=sample;

data mydblib.temp (DBCREATE_TABLE_OPTS='PARTITIONING
      KEY (X) USING HASHING');
  x=1; output;
  x=2; output;
run;

Given this data set option, the following DB2 SQL statement is passed by the SAS/ACCESS engine to DB2 in order to create the DB2 table:

CREATE TABLE TEMP (X DOUBLE) PARTITIONING 
   KEY (X) USING HASHING

Chapter Contents
Previous
Next
Top of Page