The LIBNAME Statement for Relational Databases DBGEN_NAME= LIBNAME Option 87
libname mydblib db2 user=testuser
using=testpass db=sales
dbconinit=’exec salestab_stored_proc’
dbconterm=’drop table bonuses’;
See Also
“DBCONINIT= LIBNAME Option” on page 84
DBCREATE_TABLE_OPTS= LIBNAME Option
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement
Valid in:
the SAS/ACCESS LIBNAME statement
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’
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.
See Also
To apply this option to an individual data set, see the data set option
“DBCREATE_TABLE_OPTS= Data Set Option” on page 172.
DBGEN_NAME= LIBNAME Option
Specifies whether to automatically rename DBMS columns containing characters that SAS does not
allow, such as $, to valid SAS variable names
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle,
Microsoft SQL Server, SYBASE, Teradata
