The LIBNAME Statement for Relational Databases

Overview: LIBNAME Statement for Relational Databases
Assigning a Libref Interactively
LIBNAME Statement Syntax for Relational Databases
ACCESS= LIBNAME Option
ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS= LIBNAME Option
ADJUST_NCHAR_COLUMN_LENGTHS= LIBNAME Option
AUTHDOMAIN= LIBNAME Option
AUTHID=  LIBNAME Option
AUTOCOMMIT= LIBNAME Option
BL_KEEPIDENTITY= LIBNAME Option
BL_KEEPNULLS= LIBNAME Option
BL_LOG= LIBNAME Option
BL_NUM_ROW_SEPS= LIBNAME Option
BL_OPTIONS= LIBNAME Option
BL_PORT= LIBNAME Option
BULKEXTRACT= LIBNAME Option
BULKLOAD= LIBNAME Option
BULKUNLOAD= LIBNAME Option
CAST= LIBNAME Option
CAST_OVERHEAD_MAXPERCENT= LIBNAME Option
CELLPROP= LIBNAME Option
CHAR_AS_NCHAR= LIBNAME Option
COMMAND_TIMEOUT= LIBNAME Option
CONNECTION= LIBNAME Option
CONNECTION_GROUP= LIBNAME Option
CONNECTION_TIMEOUT= LIBNAME Option
CURSOR_TYPE= LIBNAME Option
DB_LENGTH_SEMANTICS_BYTE= LIBNAME Option
DB_OBJECTS= LIBNAME Option
DBCLIENT_MAX_BYTES= LIBNAME Option
DBCOMMIT= LIBNAME Option
DBCONINIT= LIBNAME Option
DBCONTERM= LIBNAME Option
DBCREATE_TABLE_EXTERNAL= LIBNAME Option
DBCREATE_TABLE_OPTS= LIBNAME Option
DBGEN_NAME= LIBNAME Option
DBINDEX= LIBNAME Option
DBLIBINIT= LIBNAME Option
DBLIBTERM= LIBNAME Option
DBLINK= LIBNAME Option
DBMAX_TEXT= LIBNAME Option
DBMSTEMP= LIBNAME Option
DBNULLKEYS= LIBNAME Option
DBPROMPT= LIBNAME Option
DBSASLABEL= LIBNAME Option
DBSERVER_MAX_BYTES= LIBNAME Option
DBSLICEPARM= LIBNAME Option
DEFER= LIBNAME Option
DEGREE= LIBNAME Option
DELETE_MULT_ROWS= LIBNAME Option
DIMENSION= LIBNAME Option
DIRECT_EXE= LIBNAME Option
DIRECT_SQL= LIBNAME Option
ENABLE_BULK= LIBNAME Option
ERRLIMIT= LIBNAME Option
ESCAPE_BACKSLASH= LIBNAME Option
FASTEXPORT= LIBNAME Option
FETCH_IDENTITY= LIBNAME Option
IGNORE_ READ_ONLY_COLUMNS= LIBNAME Option
IN= LIBNAME Option
INSERT_SQL= LIBNAME Option
INSERTBUFF= LIBNAME Option
INTERFACE= LIBNAME Option
KEYSET_SIZE= LIBNAME Option
LOCATION= LIBNAME Option
LOCKTABLE= LIBNAME Option
LOCKTIME= LIBNAME Option
LOCKWAIT= LIBNAME Option
LOGDB= LIBNAME Option
LOGIN_TIMEOUT= LIBNAME Option
MAX_CONNECTS= LIBNAME Option
MODE= LIBNAME Option
MULTI_DATASRC_OPT= LIBNAME Option
MULTISTMT= LIBNAME Option
OR_BINARY_DOUBLE= LIBNAME Option
OR_ENABLE_INTERRUPT= LIBNAME Option
OR_UPD_NOWHERE= LIBNAME Option
PACKETSIZE= LIBNAME Option
PARTITION_KEY= LIBNAME Option
PREFETCH= LIBNAME Option
PRESERVE_COL_NAMES= LIBNAME Option
PRESERVE_TAB_NAMES= LIBNAME Option
QUALIFIER= LIBNAME Option
QUALIFY_ROWS= LIBNAME Option
QUERY_BAND= LIBNAME Option
QUERY_TIMEOUT= LIBNAME Option
QUOTE_CHAR= LIBNAME Option
QUOTED_IDENTIFIER= LIBNAME Option
READBUFF= LIBNAME Option
READ_ISOLATION_LEVEL= LIBNAME Option
READ_LOCK_TYPE= LIBNAME Option
READ_MODE_WAIT= LIBNAME Option
REMOTE_DBTYPE= LIBNAME Option
REREAD_EXPOSURE= LIBNAME Option
RESULTS= LIBNAME Option
SCHEMA= LIBNAME Option
SESSIONS= LIBNAME Option
SHOW_SYNONYMS= LIBNAME Option
SLEEP= LIBNAME Option
SPOOL= LIBNAME Option
SQL_FUNCTIONS= LIBNAME Option
SQL_FUNCTIONS_COPY= LIBNAME Option
SQL_OJ_ANSI= LIBNAME Option
SQLGENERATION= LIBNAME Option
STRINGDATES= LIBNAME Option
TEMPORAL_QUALIFIER= LIBNAME Option
TENACITY= LIBNAME Option
TPT= LIBNAME Option
TR_ENABLE_INTERRUPT= LIBNAME Option
TRACE= LIBNAME Option
TRACEFILE= LIBNAME Option
UPDATE_ISOLATION_LEVEL= LIBNAME Option
UPDATE_LOCK_TYPE= LIBNAME Option
UPDATE_MODE_WAIT= LIBNAME Option
UPDATE_MULT_ROWS= LIBNAME Option
UPDATE_SQL= LIBNAME Option
UPDATEBUFF= LIBNAME Option
USE_ODBC_CL= LIBNAME Option
UTILCONN_TRANSIENT= LIBNAME Option
Copyright © SAS Institute Inc. All rights reserved.