The LIBNAME Statement

Overview: LIBNAME Statement for Relational Databases
Assigning a Libref Interactively
Dictionary

ABCDEFGHIKLMOPQRSTUW

LIBNAME Statement: External Databases
ACCESS= LIBNAME Statement Option
ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS= LIBNAME Statement Option
ADJUST_NCHAR_COLUMN_LENGTHS= LIBNAME Statement Option
ALLOW_LARGE_RESULTS= LIBNAME Statement Option
ALLOWED_SQLCODES= LIBNAME Statement Option
ANALYZE= LIBNAME Statement Option
AUTHDOMAIN= LIBNAME Statement Option
AUTHID= LIBNAME Statement Option
AUTOCOMMIT= LIBNAME Statement Option
BATCH_UPDATE= LIBNAME Statement Option
BL_ACCOUNTNAME= LIBNAME Statement Option
BL_APPLICATIONID= LIBNAME Statement Option
BL_AWS_CONFIG_FILE= LIBNAME Statement Option
BL_AWS_CREDENTIALS_FILE= LIBNAME Statement Option
BL_AWS_PROFILE_NAME= LIBNAME Statement Option
BL_AZURE_SAS= LIBNAME Statement Option
BL_BUCKET= LIBNAME Statement Option
BL_COMPRESS= LIBNAME Statement Option
BL_CONFIG= LIBNAME Statement Option
BL_DEFAULT_DIR= LIBNAME Statement Option
BL_DELETE_DATAFILE= LIBNAME Statement Option
BL_DELIMITER= LIBNAME Statement Option
BL_DNSSUFFIX= LIBNAME Statement Option
BL_ENCKEY= LIBNAME Statement Option
BL_FILESYSTEM= LIBNAME Statement Option
BL_FOLDER= LIBNAME Statement Option
BL_FORMAT= LIBNAME Statement Option
BL_FORMAT_OPT= LIBNAME Statement Option
BL_HOST= LIBNAME Statement Option
BL_IAM_ASSUME_ROLE_ARN= LIBNAME Statement Option
BL_IAM_ASSUME_ROLE_NAME= LIBNAME Statement Option
BL_IAM_ROLE= LIBNAME Statement Option
BL_IDENTITY= LIBNAME Statement Option
BL_INFORMIXDIR= LIBNAME Statement Option
BL_KEEPIDENTITY= LIBNAME Statement Option
BL_KEEPNULLS= LIBNAME Statement Option
BL_KEY= LIBNAME Statement Option
BL_LOG= LIBNAME Statement Option
BL_MAXERRORS= LIBNAME Statement Option
BL_NUM_DATAFILES= LIBNAME Statement Option
BL_NUM_READ_THREADS= LIBNAME Statement Option
BL_OPTIONS= LIBNAME Statement Option
BL_PORT= LIBNAME Statement Option
BL_RECOVERABLE= LIBNAME Statement Option
BL_REGION= LIBNAME Statement Option
BL_SECRET= LIBNAME Statement Option
BL_TIMEOUT= LIBNAME Statement Option
BL_TOKEN= LIBNAME Statement Option
BL_USE_ESCAPE= LIBNAME Statement Option
BL_USE_LOG= LIBNAME Statement Option
BL_USE_PIPE= LIBNAME Statement Option
BL_USE_SSL= LIBNAME Statement Option
BL_WRITEBUFF= LIBNAME Statement Option
BULKLOAD= LIBNAME Statement Option
BULKUNLOAD= LIBNAME Statement Option
CAST= LIBNAME Statement Option
CAST_OVERHEAD_MAXPERCENT= LIBNAME Statement Option
CELLPROP= LIBNAME Statement Option
CHAR_AS_NCHAR= LIBNAME Statement Option
CLIENT_ENCODING= LIBNAME Statement Option
CLIENT_ID= LIBNAME Statement Option
CLIENT_SECRET= LIBNAME Statement Option
COMMAND_TIMEOUT= LIBNAME Statement Option
CONNECTION= LIBNAME Statement Option
CONNECTION_GROUP= LIBNAME Statement Option
CONOPTS= LIBNAME Statement Option
CURSOR_TYPE= LIBNAME Statement Option
DATETIME2= LIBNAME Statement Option
DB_LENGTH_SEMANTICS_BYTE= LIBNAME Statement Option
DB_OBJECTS= LIBNAME Statement Option
DBCLIENT_ENCODING_FIXED= LIBNAME Statement Option
DBCLIENT_MAX_BYTES= LIBNAME Statement Option
DBCOMMIT= LIBNAME Statement Option
DBCONINIT= LIBNAME Statement Option
DBCONTERM= LIBNAME Statement Option
DBCREATE_TABLE_EXTERNAL= LIBNAME Statement Option
DBCREATE_TABLE_LOCATION= LIBNAME Statement Option
DBCREATE_TABLE_OPTS= LIBNAME Statement Option
DBGEN_NAME= LIBNAME Statement Option
DBINDEX= LIBNAME Statement Option
DBLIBINIT= LIBNAME Statement Option
DBLIBTERM= LIBNAME Statement Option
DBLINK= LIBNAME Statement Option
DBMAX_TEXT= LIBNAME Statement Option
DBMAX_TEXT_TYPES= LIBNAME Statement Option
DBMSTEMP= LIBNAME Statement Option
DBNULLKEYS= LIBNAME Statement Option
DBNULLWHERE= LIBNAME Statement Option
DBPROMPT= LIBNAME Statement Option
DBSASLABEL= LIBNAME Statement Option
DBSERVER_ENCODING_FIXED= LIBNAME Statement Option
DBSERVER_ENCODING_FIXED= LIBNAME Statement Option
DBSERVER_MAX_BYTES= LIBNAME Statement Option
DBSLICEPARM= LIBNAME Statement Option
DEFAULT_AUTH_PLUGIN= LIBNAME Statement Option
DEFER= LIBNAME Statement Option
DEGREE= LIBNAME Statement Option
DELETE_MULT_ROWS= LIBNAME Statement Option
DIMENSION= LIBNAME Statement Option
DIRECT_EXE= LIBNAME Statement Option
DIRECT_SQL= LIBNAME Statement Option
DRIVER_TRACE= LIBNAME Statement Option
DRIVER_TRACEFILE= LIBNAME Statement Option
DRIVER_TRACEOPTIONS= LIBNAME Statement Option
DRIVER_VENDOR= LIBNAME Statement Option
ENABLE_BULK= LIBNAME Statement Option
ERRLIMIT= LIBNAME Statement Option
ESCAPE_BACKSLASH= LIBNAME Statement Option
FASTEXPORT= LIBNAME Statement Option
FASTLOAD= LIBNAME Statement Option
FETCH_IDENTITY= LIBNAME Statement Option
FETCH_NUMERIC_TYPE= LIBNAME Statement Option
FETCH_TWFS_AS_TIME= LIBNAME Statement Option
GO_ENABLE_LOGGING= LIBNAME Statement Option
GO_LOG_FILE= LIBNAME Statement Option
GO_LOG_FORMAT= LIBNAME Statement Option
GO_LOG_LEVEL= LIBNAME Statement Option
HDFS_PRINCIPAL= LIBNAME Statement Option
IGNORE_BASELINE= LIBNAME Statement Option
IGNORE_FEDSQL_OBJECTS= LIBNAME Statement Option
IGNORE_READ_ONLY_COLUMNS= LIBNAME Statement Option
IMPALA_PRINCIPAL= LIBNAME Statement Option
IN= LIBNAME Statement Option
INSERT_SQL= LIBNAME Statement Option
INSERTBUFF= LIBNAME Statement Option
INTERFACE= LIBNAME Statement Option
KEYSET_SIZE= LIBNAME Statement Option
LARGE_RESULTS_DATASET= LIBNAME Statement Option
LARGE_RESULTS_EXPIRATION_TIME= LIBNAME Statement Option
LARGE_RESULTS_PROJECT= LIBNAME Statement Option
LOCATION= LIBNAME Statement Option
LOCKTABLE= LIBNAME Statement Option
LOCKTIME= LIBNAME Statement Option
LOCKWAIT= LIBNAME Statement Option
LOGDB= LIBNAME Statement Option
LOGIN_TIMEOUT= LIBNAME Statement Option
MAX_BINARY_LEN= LIBNAME Statement Option
MAX_CHAR_LEN= LIBNAME Statement Option
MAX_CONNECTS= LIBNAME Statement Option
MAX_STRING_SIZE= LIBNAME Statement Option
MODE= LIBNAME Statement Option
MULTI_DATASRC_OPT= LIBNAME Statement Option
MULTISTMT= LIBNAME Statement Option
OR_BINARY_DOUBLE= LIBNAME Statement Option
OR_ENABLE_INTERRUPT= LIBNAME Statement Option
OR_UPD_NOWHERE= LIBNAME Statement Option
OVERRIDE_RESP_LEN= LIBNAME Statement Option
PACKETSIZE= LIBNAME Statement Option
PARMDEFAULT= LIBNAME Statement Option
PARMSTRING= LIBNAME Statement Option
PARTITION_KEY= LIBNAME Statement Option
POST_DML_STMT_OPTS= LIBNAME Statement Option
POST_STMT_OPTS= LIBNAME Statement Option
PRESERVE_COL_NAMES= LIBNAME Statement Option
PRESERVE_COMMENTS= LIBNAME Statement Option
PRESERVE_GUID= LIBNAME Statement Option
PRESERVE_TAB_NAMES= LIBNAME Statement Option
PRESERVE_USER= LIBNAME Statement Option
PROGRAM_NAME= LIBNAME Statement Option
PROJECT_LIST= LIBNAME Statement Option
PROPERTIES= LIBNAME Statement Option
PROXY= LIBNAME Statement Option
QUALIFIER= LIBNAME Statement Option
QUALIFY_ROWS= LIBNAME Statement Option
QUERY_BAND= LIBNAME Statement Option
QUERY_TAG= LIBNAME Statement Option
QUERY_TIMEOUT= LIBNAME Statement Option
QUOTE_CHAR= LIBNAME Statement Option
QUOTED_IDENTIFIER= LIBNAME Statement Option
READ_ISOLATION_LEVEL= LIBNAME Statement Option
READ_LOCK_TYPE= LIBNAME Statement Option
READ_METHOD= LIBNAME Statement Option
READ_MODE= LIBNAME Statement Option
READ_MODE_WAIT= LIBNAME Statement Option
READBUFF= LIBNAME Statement Option
REFRESH_TOKEN= LIBNAME Statement Option
REMOTE_DBTYPE= LIBNAME Statement Option
REREAD_EXPOSURE= LIBNAME Statement Option
RESULTS= LIBNAME Statement Option
SAS_DBMS_AUTOMETADATA= LIBNAME Statement Option
SCANSTRINGCOLUMNS= LIBNAME Statement Option
SCHEMA= LIBNAME Statement Option
SCRATCH_DB= LIBNAME Statement Option
SESSIONS= LIBNAME Statement Option
SHOW_SYNONYMS= LIBNAME Statement Option
SKIP_IDENTITY_COL= LIBNAME Statement Option
SLEEP= LIBNAME Statement Option
SPOOL= LIBNAME Statement Option
SQL_FUNCTIONS= LIBNAME Statement Option
SQL_FUNCTIONS_COPY= LIBNAME Statement Option
SQL_OJ_ANSI= LIBNAME Statement Option
SQLGENERATION= LIBNAME Statement Option
SSL_CA= LIBNAME Statement Option
SSL_CERT= LIBNAME Statement Option
SSL_CIPHER= LIBNAME Statement Option
SSL_KEY= LIBNAME Statement Option
SSLMODE= LIBNAME Statement Option
STRINGDATES= LIBNAME Statement Option
SUB_CHAR= LIBNAME Statement Option
SYNONYMS= LIBNAME Statement Option
TABLE_TYPE= LIBNAME Statement Option
TEMP_CTAS= LIBNAME Statement Option
TEMPORAL_QUALIFIER= LIBNAME Statement Option
TENACITY= LIBNAME Statement Option
TPT= LIBNAME Statement Option
TPT_DATA_ENCRYPTION= LIBNAME Statement Option
TPT_MAX_SESSIONS= LIBNAME Statement Option
TPT_MIN_SESSIONS= LIBNAME Statement Option
TPT_UNICODE_PASSTHRU= LIBNAME Statement Option
TR_ENABLE_INTERRUPT= LIBNAME Statement Option
TRACE= LIBNAME Statement Option
TRACEFILE= LIBNAME Statement Option
TRACEFLAGS= LIBNAME Statement Option
TRANSCODE_FAIL= LIBNAME Statement Option
UPDATE_ISOLATION_LEVEL= LIBNAME Statement Option
UPDATE_LOCK_TYPE= LIBNAME Statement Option
UPDATE_MODE_WAIT= LIBNAME Statement Option
UPDATE_MULT_ROWS= LIBNAME Statement Option
UPDATE_SQL= LIBNAME Statement Option
UPDATEBUFF= LIBNAME Statement Option
USE_DATADIRECT= LIBNAME Statement Option
USE_INFORMATION_SCHEMA= LIBNAME Statement Option
USE_ODBC_CL= LIBNAME Statement Option
USE_SP_TABLES= LIBNAME Statement Option
UTILCONN_TRANSIENT= LIBNAME Statement Option
WARN_BIGINT= LIBNAME Statement Option
Last updated: February 3, 2026