172 DBCREATE_TABLE_OPTS= Data Set Option Chapter 10
Example
In the following example, the function that is passed to the DBMS with the
DBCONDITION= option causes the DBMS to return to SAS only the rows that satisfy
the condition.
proc sql;
create view smithnames as
select lastname from myoralib.employees
(dbcondition="where soundex(lastname) = soundex(’SMYTHE’)" )
using libname myoralib oracle user=testuser pw=testpass path=dbmssrv;
select lastname from smithnames;
DBCREATE_TABLE_OPTS= Data Set Option
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value: none
Syntax
DBCREATE_TABLE_OPTS=’DBMS-SQL-clauses’
Syntax Description
DBMS-SQL-clauses
are one or more DBMS-specific clauses that can be appended to the end of an SQL
CREATE TABLE statement.
Details
This option 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. This option applies only when you are creating a DBMS table by
specifying a libref associated with DBMS data.
Example
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.
