Libname Options Syntax Listed by Product

SAS/ACCESS

Name	Syntax and Description
ACCESS= LIBNAME Option	ACCESS=READONLY Determines the access level with which a libref connection is opened. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS= LIBNAME Option	ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS=YES \| NO Specifies whether to adjust the lengths of CHAR or VARCHAR data type columns that byte semantics specify. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ADJUST_NCHAR_COLUMN_LENGTHS= LIBNAME Option	ADJUST_NCHAR_COLUMN_LENGTHS=YES \| NO Specifies whether to adjust the lengths of CHAR or VARCHAR data type columns. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
AUTHDOMAIN= LIBNAME Option	AUTHDOMAIN= auth-domain Allows connection to a server by specifying the name of an authentication domain metadata object. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
AUTHID= LIBNAME Option	AUTHID= authorization-ID Allows qualified table names with an authorization ID, a user ID, or a group ID. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
AUTOCOMMIT= LIBNAME Option	AUTOCOMMIT=YES \| NO Indicates whether updates are committed immediately after they are submitted. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_KEEPIDENTITY= LIBNAME Option	BL_KEEPIDENTITY=YES \| NO Determines whether the identity column that is created during bulk loading is populated with values that Microsoft SQL Server generates or with values that the user provides. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_KEEPNULLS= LIBNAME Option	BL_KEEPNULLS=YES \| NO Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during bulk loading. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_LOG= LIBNAME Option	BL_LOG= filename Specifies the name of the error file where all errors are written when BULKLOAD=YES. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_NUM_ROW_SEPS= LIBNAME Option	BL_NUM_ROW_SEPS=<integer> Specifies the number of newline characters to use as the row separator for the load or extract data stream. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_OPTIONS= LIBNAME Option	BL_OPTIONS= 'option < …, option > ' Passes options to the DBMS bulk-load facility, which affects how it loads and processes data. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BULKEXTRACT= LIBNAME Option	BULKEXTRACT=YES \| NO Rapidly retrieves (fetches) a large number of rows from a data set. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BULKLOAD= LIBNAME Option	BULKLOAD=YES \| NO Determines whether SAS uses a DBMS facility to insert data into a DBMS table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BULKUNLOAD= LIBNAME Option	BULKUNLOAD=YES \| NO Rapidly retrieves (fetches) a large number of rows from a data set. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CAST= LIBNAME Option	CAST=YES \| NO Specifies whether SAS or the Teradata DBMS server performs data conversions. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CAST_OVERHEAD_MAXPERCENT= LIBNAME Option	CAST_OVERHEAD_MAXPERCENT= < n > Specifies the overhead limit for data conversions to perform in Teradata instead of SAS. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CELLPROP= LIBNAME Option	CELLPROP=VALUE \| FORMATTED_VALUE Modifies the metadata and content of a result data set that the MDX command defines. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
COMMAND_TIMEOUT= LIBNAME Option	COMMAND_TIMEOUT= number-of-seconds Specifies the number of seconds to wait before a data source command times out. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CONNECTION= LIBNAME Option	CONNECTION=SHAREDREAD \| UNIQUE \| SHARED \| GLOBALREAD \| GLOBAL Specifies whether operations on a single or multiple librefs share a connection to the DBMS. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CONNECTION_GROUP= LIBNAME Option	CONNECTION_GROUP= connection-group-name Causes operations on multiple librefs and on multiple SQL pass-through facility CONNECT statements to share a connection to the DBMS. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CONNECTION_TIMEOUT= LIBNAME Option	CONNECTION_TIMEOUT= number-of-seconds Specifies the number of seconds to wait before a connection times out. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CURSOR_TYPE= LIBNAME Option	CURSOR_TYPE=DYNAMIC \| FORWARD_ONLY \| KEYSET_DRIVEN \| STATIC Specifies the cursor type for read-only and updatable cursors. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DB_LENGTH_SEMANTICS_BYTE= LIBNAME Option	DB_LENGTH_SEMANTICS_BYTE=YES \| NO Indicates whether CHAR and VARCHAR2 column lengths are specified in bytes or characters when creating an Oracle table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCLIENT_MAX_BYTES= LIBNAME Option	DBCLIENT_MAX_BYTES= max-client-bytes Specifies the maximum number of bytes per single character in the database client encoding, which matches SAS encoding. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCOMMIT= LIBNAME Option	DBCOMMIT= n Causes an automatic COMMIT (permanently writing data to the DBMS) after processing a specified number of rows. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCONINIT= LIBNAME Option	DBCONINIT=<'>DBMS-user-command<'> Specifies a user-defined initialization command to execute immediately after every connection to the DBMS that is within the scope of the LIBNAME statement or libref. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCONTERM= LIBNAME Option	DBCONTERM=<'>DBMS-user-command<'> Specifies a user-defined termination command to execute before every disconnect from the DBMS that is within the scope of the LIBNAME statement or libref. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCREATE_TABLE_OPTS= LIBNAME Option	DBCREATE_TABLE_OPTS='DBMS-SQL-clauses' Specifies DBMS-specific syntax to add to the CREATE TABLE statement. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBGEN_NAME= LIBNAME Option	DBGEN_NAME=DBMS \| SAS Specifies how SAS automatically renames to valid SAS variable names any DBMS columns that contain characters that SAS does not allow. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBINDEX= LIBNAME Option	DBINDEX=YES \| NO Improves performance when processing a join that involves a large DBMS table and a small SAS data set. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBLIBINIT= LIBNAME Option	DBLIBINIT=<'>DBMS-user-command<'> Specifies a user-defined initialization command to execute once within the scope of the LIBNAME statement or libref that established the first connection to the DBMS. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBLIBTERM= LIBNAME Option	DBLIBTERM=<'>DBMS-user-command<'> Specifies a user-defined termination command to execute once, before the DBMS that is associated with the first connection made by the LIBNAME statement or libref disconnects. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBLINK= LIBNAME Option	DBLINK= database-link Specifies a link from your 1) local database to database objects on another server [Oracle], or 2) default database to another database on the server to which you are connected [Sybase]. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBMAX_TEXT= LIBNAME Option	DBMAX_TEXT=<integer> Determines the length of any very long DBMS character data type that is read into SAS or written from SAS when using a SAS/ACCESS engine. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBMSTEMP= LIBNAME Option	DBMSTEMP=YES \| NO Specifies whether SAS creates temporary or permanent tables. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBNULLKEYS= LIBNAME Option	DBNULLKEYS=YES \| NO Controls the format of the WHERE clause when you use the DBKEY= data set option. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBPROMPT= LIBNAME Option	DBPROMPT=YES \| NO Specifies whether SAS displays a window that prompts the user to enter DBMS connection information before connecting to the DBMS in interactive mode. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBSASLABEL= LIBNAME Option	DBSASLABEL=COMPAT \| NONE Specifies the column labels an engine uses. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBSERVER_MAX_BYTES= LIBNAME Option	DBSERVER_MAX_BYTES= max-server-bytes Specifies the maximum number of bytes per single character in the database server encoding. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBSLICEPARM= LIBNAME Option	DBSLICEPARM=NONE \| THREADED_APPS \| ALL DBSLICEPARM=( NONE \| THREADED_APPS \| ALL< max-threads > ) DBSLICEPARM=( NONE \| THREADED_APPS \| ALL<, max-threads > ) Controls the scope of DBMS threaded reads and the number of threads. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DEFER= LIBNAME Option	DEFER=YES\| NO Specifies when the connection to the DBMS occurs. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DEGREE= LIBNAME Option	DEGREE=ANY \| 1 Determines whether DB2 uses parallelism. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DELETE_MULT_ROWS= LIBNAME Option	DELETE_MULT_ROWS=YES \| NO Indicates whether to let SAS delete multiple rows from a data source, such as a DBMS table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DIMENSION= LIBNAME Option	DIMENSION=YES \| NO Specifies whether the database creates dimension tables or fact tables. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DIRECT_EXE= LIBNAME Option	DIRECT_EXE=DELETE Lets an SQL delete statement be passed directly to a DBMS with pass-through. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DIRECT_SQL= LIBNAME Option	DIRECT_SQL=YES \| NO \| NONE \| NOGENSQL \| NOWHERE \| NOFUNCTIONS \| NOMULTOUTJOINS Specifies whether generated SQL is passed to the DBMS for processing. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ENABLE_BULK= LIBNAME Option	ENABLE_BULK=YES \| NO Lets the connection process bulk copy when loading data into a Sybase table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ERRLIMIT= LIBNAME Option	ERRLIMIT= integer Specifies the number of errors that are allowed while using the Fastload utility before SAS stops loading data to Teradata. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ESCAPE_BACKSLASH= LIBNAME Option	ESCAPE_BACKSLASH=YES \| NO Specifies whether backslashes in literals are preserved during data copy from a SAS data set to a table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
FASTEXPORT= LIBNAME Option	FASTEXPORT=YES \| NO Specifies whether the SAS/ACCESS engine uses the TPT API to read data. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
FETCH_IDENTITY= LIBNAME Option	FETCH_IDENTITY=YES \| NO Returns the value of the last inserted identity value. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
IGNORE_ READ_ONLY_COLUMNS= LIBNAME Option	IGNORE_READ_ONLY_COLUMNS=YES \| NO Specifies whether to ignore or include columns where data types are read-only when generating an SQL statement for inserts or updates. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
IN= LIBNAME Option	IN= 'database-name.tablespace-name'\| 'DATABASE database-name' Lets you specify the database and table space in which you want to create a new table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
INSERT_SQL= LIBNAME Option	INSERT_SQL=YES \| NO Determines the method to use to insert rows into a data source. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
INSERTBUFF= LIBNAME Option	INSERTBUFF= positive-integer Specifies the number of rows in a single DBMS insert. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
INTERFACE= LIBNAME Option	INTERFACE=<'>filename<'> Specifies the name and location of the interfaces file that is searched when you connect to the Sybase server. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
KEYSET_SIZE= LIBNAME Option	KEYSET_SIZE= number-of-rows Specifies the number of rows that are keyset-driven. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOCATION= LIBNAME Option	LOCATION= location Allows further qualification of exactly where a table resides. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOCKTABLE= LIBNAME Option	LOCKTABLE=EXCLUSIVE \| SHARE Places exclusive or shared locks on tables. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOCKTIME= LIBNAME Option	LOCKTIME= positive-integer Specifies the number of seconds to wait until rows are available for locking. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOCKWAIT= LIBNAME Option	LOCKWAIT=YES \| NO Specifies whether to wait indefinitely until rows are available for locking. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOGDB= LIBNAME Option	LOGDB= < database-name > Redirects to an alternate database-specific table that FastExport creates or MultiLoad uses. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOGIN_TIMEOUT= LIBNAME Option	LOGIN_TIMEOUT= numeric-value Specifies the default login time-out for connecting to and accessing data sources in a library. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
MAX_CONNECTS= LIBNAME Option	MAX_CONNECTS= numeric-value Specifies the maximum number of simultaneous connections that Sybase allows. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
MODE= LIBNAME Option	MODE=TERADATA \| ANSI Specifies whether the connection to Teradata uses the ANSI or Teradata mode. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
MULTI_DATASRC_OPT= LIBNAME Option	MULTI_DATASRC_OPT=NONE \| IN_CLAUSE Used in place of DBKEY to improve performance when processing a join between two data sources. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
MULTISTMT= LIBNAME Option	MULTISTMT=YES \| NO Specifies whether insert statements are sent to Teradata one at a time or in a group. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
OR_ENABLE_INTERRUPT= LIBNAME Option	OR_ENABLE_INTERRUPT=YES \| NO Allows interruption of any long-running SQL processes on the DBMS server. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
OR_UPD_NOWHERE= LIBNAME Option	OR_UPD_NOWHERE=YES \| NO Specifies whether SAS uses an extra WHERE clause when updating rows with no locking. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PACKETSIZE= LIBNAME Option	PACKETSIZE= numeric-value Allows specification of the packet size for Sybase to use. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PARTITION_KEY= LIBNAME Option	PARTITION_KEY='column-name' Specifies the column name to use as the partition key for creating fact tables. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PREFETCH= LIBNAME Option	PREFETCH='unique_storename, [#sessions,algorithm]' Enables the PreFetch facility on tables that the libref (defined with the LIBNAME statement) accesses. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PRESERVE_COL_NAMES= LIBNAME Option	PRESERVE_COL_NAMES=YES \| NO Preserves spaces, special characters, and case sensitivity in DBMS column names when you create DBMS tables. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PRESERVE_TAB_NAMES= LIBNAME Option	PRESERVE_TAB_NAMES=YES \| NO Preserves spaces, special characters, and case sensitivity in DBMS table names. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUALIFIER= LIBNAME Option	QUALIFIER= <qualifier-name> Allows identification of such database objects as tables and views with the specified qualifier. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUALIFY_ROWS= LIBNAME Option	QUALIFY_ROWS=YES \| NO Uniquely qualifies all member values in a result set. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUERY_BAND= LIBNAME Option	QUERY_BAND=”pair-name=pair_value” FOR SESSION; Specifies whether to set a query band for the current session. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUERY_TIMEOUT= LIBNAME Option	QUERY_TIMEOUT= number-of-seconds Specifies the number of seconds of inactivity to wait before canceling a query. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUOTE_CHAR= LIBNAME Option	QUOTE_CHAR= character Specifies which quotation mark character to use when delimiting identifiers. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUOTED_IDENTIFIER= LIBNAME Option	QUOTED_IDENTIFIER=YES \| NO Allows specification of table and column names with embedded spaces and special characters. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READ_ISOLATION_LEVEL= LIBNAME Option	READ_ISOLATION_LEVEL= DBMS-specific value Defines the degree of isolation of the current application process from other concurrently running application processes. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READ_LOCK_TYPE= LIBNAME Option	READ_LOCK_TYPE=ROW \| PAGE \| TABLE \| NOLOCK \|VIEW Specifies how data in a DBMS table is locked during a READ transaction. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READ_MODE_WAIT= LIBNAME Option	READ_MODE_WAIT=YES \| NO During SAS/ACCESS read operations, specifies whether Teradata should wait to acquire a lock or fail the request when a different user has already locked the DBMS resource. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READBUFF= LIBNAME Option	READBUFF= integer Specifies the number of rows of DBMS data to read into the buffer. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
REMOTE_DBTYPE= LIBNAME Option	REMOTE_DBTYPE=LUW \| ZOS Specifies whether the libref points to a database server on z/OS or to one on Linux, UNIX, or Windows. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
REREAD_EXPOSURE= LIBNAME Option	REREAD_EXPOSURE=YES \| NO Specifies whether the SAS/ACCESS engine functions like a random access engine for the scope of the LIBNAME statement. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
RESULTS= LIBNAME Option	RESULTS=MEMORY \| SERVER \| DISK Determines where to store query results. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SCHEMA= LIBNAME Option	SCHEMA= schema-name Allows reading of such database objects as tables and views in the specified schema. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SESSIONS= LIBNAME Option	SESSIONS= number-of-sessions Specifies how many Teradata sessions to be logged on when using FastLoad, FastExport, or Multiload. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SHOW_SYNONYMS= LIBNAME Option	SHOW_SYNONYMS=<YES \| NO> Specifies whether PROC DATASETS shows synonyms, tables, views, or materialized views for the current user and schema if you specified the SCHEMA= option. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SPOOL= LIBNAME Option	SPOOL=YES \| NO \| DBMS Specifies whether SAS creates a utility spool file during read transactions that read data more than once. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SQL_FUNCTIONS= LIBNAME Option	SQL_FUNCTIONS=ALL \| "<libref.member>" \| "EXTERNAL_APPEND=<libref.member>" Customizes the in-memory SQL dictionary function list for this particular LIBNAME statement. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SQL_FUNCTIONS_COPY= LIBNAME Option	SQL_FUNCTIONS_COPY=<libref.member> \| SASLOG Writes the function associated with this particular LIBNAME statement to a SAS data set or the SAS log. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SQL_OJ_ANSI= LIBNAME Option	SQL_OJ_ANSI=YES \| NO Specifies whether to pass ANSI outer-join syntax through to the database. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SQLGENERATION= LIBNAME Option	SQLGENERATION=<(>NONE \| DBMS <DBMS='engine1 engine2 ... enginen'> <<EXCLUDEDB=engine \| 'engine1 engine2 ... enginen'>> <<EXCLUDEPROC="engine=' proc1 proc2 ... procn' enginen='proc1 proc2 ... procn' "> <)>> SQLGENERATION=" " Specifies whether and when SAS procedures generate SQL for in-database processing of source data. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
STRINGDATES= LIBNAME Option	STRINGDATES=YES \| NO Specifies whether to read date and time values from the database as character strings or as numeric date values. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TEMPORAL_QUALIFIER= LIBNAME Option	TEMPORAL_QUALIFIER=CURRENT VALIDTIME \| VALIDTIME AS OF PERIOD 'period' \| SEQUENCED VALIDTIME \| NONSEQUENCED VALIDTIME 'period' TEMPORAL_QUALIFIER=CURRENT TRANSACTIONTIME \| TRANSACTIONTIME AS OF PERIOD 'period' NONSEQUENCED TRANSACTIONTIME Specifies time-dimension criteria for retrieving data from Teradata. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TPT= LIBNAME Option	TPT=YES \| NO Specifies whether SAS uses the Teradata Parallel Transporter (TPT) API to load data when SAS requests a Fastload, MultiLoad, or Multi-Statement insert. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TRACE= LIBNAME Option	TRACE=YES \| NO Specifies whether to turn on tracing information for use in debugging. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TRACEFILE= LIBNAME Option	TRACEFILE= filename \| <'>path-and-filename<'> Specifies the filename to which the DBMS driver manager writes trace information. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UPDATE_ISOLATION_LEVEL= LIBNAME Option	UPDATE_ISOLATION_LEVEL= DBMS-specific-value Defines the degree of isolation of the current application process from other concurrently running application processes. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UPDATE_LOCK_TYPE= LIBNAME Option	UPDATE_LOCK_TYPE=ROW \| PAGE \| TABLE \| NOLOCK \|VIEW Specifies how data in a DBMS table is locked during an update transaction. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UPDATE_MODE_WAIT= LIBNAME Option	UPDATE_MODE_WAIT=YES \| NO Specifies during SAS/ACCESS Update operations whether Teradata should wait to acquire a lock or fail the request when a different user has locked the DBMS resource. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UPDATE_MULT_ROWS= LIBNAME Option	UPDATE_MULT_ROWS=YES \| NO Indicates whether SAS updates multiple rows from a data source, such as a DBMS table. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UPDATE_SQL= LIBNAME Option	UPDATE_SQL=YES \| NO Determines the method that is used to update and delete rows in a data source. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UPDATEBUFF= LIBNAME Option	UPDATEBUFF= positive-integer Specifies the number of rows that are processed in a single DBMS update or delete operation. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
USE_ODBC_CL= LIBNAME Option	USE_ODBC_CL=YES \| NO Indicates whether the Driver Manager uses the ODBC Cursor Library. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference
UTILCONN_TRANSIENT= LIBNAME Option	UTILCONN_TRANSIENT=YES \| NO Enables utility connections to maintain or drop, as needed. Product: SAS/ACCESS Document: SAS/ACCESS 9.3 for Relational Databases: Reference

SAS/ACCESS Interface to R/3

A B C D G H I L M N P R S T U

Name	Syntax and Description
ABAP_NAMESPACE= LIBNAME Option	ABAP_NAMESPACE= namespace Indicates the namespace for ABAP functions and programs that SAS uses. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
ABAPFM= LIBNAME Option	ABAPFM= abap_function_name Indicates the name of the ABAP function module that SAS uses. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
ABAPPROG= LIBNAME Option	ABAPPROG= abap_program Indicates the name of the ABAP program that SAS uses. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
ASHOST= LIBNAME Option	ASHOST= application_server_host Indicates the host name or IP address of a specific SAP application server. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
AUTHDOMAIN= LIBNAME Option	AUTHDOMAIN= authentication_domain Indicates the name of the metadata-based authentication domain to use to associate user name and password credentials with an identity. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
BATCH= LIBNAME Option	BATCH= 0 \| 1 \| Y \| N Indicates whether SAS should use SAP batch jobs for data extracts. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
BUFFER_SIZE= LIBNAME Option	BUFFER_SIZE = buffersize Sets the minimum buffer size for data transfers in batch and dialog modes. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
CLIENT= LIBNAME Option	CLIENT= client Specifies the SAP logon parameter client. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
CONNECTION= LIBNAME Option	CONNECTION= SHAREDREAD \| UNIQUE \| SHARED \| GLOBALREAD \| GLOBAL Specifies whether operations on a single libref share a connection to the DBMS and whether operations on multiple librefs share a connection to the DBMS. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
CONNECTION_GROUP= LIBNAME Option	CONNECTION_GROUP= connection-group-name Causes operations on multiple librefs and on multiple pass-through facility CONNECT statements to share a connection to the DBMS. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DBGEN_NAME= LIBNAME Option	DBGEN_NAME= DBMS \| SAS Specifies how SAS automatically renames DBMS columns—when they contain characters that SAS does not allow, such as $—to valid SAS variable names. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DBPROMPT= LIBNAME Option	DBPROMPT= YES \| NO Specifies whether SAS displays a window that prompts the user to enter DBMS connection information before connecting to the DBMS in interactive mode. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DBSASLABEL= LIBNAME Option	DBSASLABEL= COMPAT \| NONE Specifies the column labels an engine uses. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DEFER= LIBNAME Option	DEFER= NO \| YES Specifies when the connection to the DBMS occurs. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DESTGROUP= LIBNAME Option	DESTGROUP= destination_group Indicates the name of the destination group for batch access to the SAP system when the SAP LIBNAME engine uses direct RFC calls. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DESTINATION= LIBNAME Option	DESTINATION= destination Indicates the destination in the saprfc.ini file if you are working with an saprfc.ini file. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DIRECT_SQL= LIBNAME Option	DIRECT_SQL= YES \| NO \| NONE \| NOGENSQL \| NOWHERE \| NOFUNCTIONS \| NOMULTOUTJOINS Lets you specify whether generated SQL is passed to the DBMS for processing. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
GROUP= LIBNAME Option	GROUP= application_server_group Indicates the name of the group of SAP application servers if you are using load balancing. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
GWHOST= LIBNAME Option	GWHOST= gateway_host_name Indicates the host name of the SAP gateway. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
GWSERV= LIBNAME Option	GWSERV= gateway_service Indicates the service of the SAP gateway. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
HOST= LIBNAME Option	HOST= rfc_server_host Indicates the host of the SAS RFC Server to use to connect to the SAP system. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
IEEE_REVERSE= LIBNAME Option	IEEE_REVERSE= Y \| N Indicates whether floating-point numbers are byte-reversed. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
INENCODING= LIBNAME Option	INENCODING= code_page Indicates the code page. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
LANGUAGE= LIBNAME Option	LANGUAGE= language Indicates the SAP logon parameter language. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
MAX_TABLE_JOINS= LIBNAME Option	MAX_TABLE_JOINS = number Indicates the number of tables that you can use in a left-outer join or an inner join in ABAP Open SQL. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
MODE= LIBNAME Option	MODE= DIRECT_SAP \| DIRECT \| RFC_SERVER \| SERVER Indicates the mode for the SAP LIBNAME engine. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
MSHOST= LIBNAME Option	MSHOST= message_server_host Indicates the host name of the message server, if you are using load balancing. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
MULTI_DATASRC_OPT= LIBNAME Option	MULTI_DATASRC_OPT= NONE \| IN_CLAUSE Used instead of the DBKEY= data set option to improve performance when you process a join between two data sources. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
NUMC_SAS_TYPE= LIBNAME Option	NUMC_SAS_TYPE= N \| C \| $ Indicates the SAS type for ABAP type NUMC. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
PASSWORD= LIBNAME Option	PASSWORD= password Indicates the SAP logon parameter password. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
PASSWORDX= LIBNAME Option	PASSWORDX= encrypted password Indicates the SAP logon parameter password in an encrypted form. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
PORT= LIBNAME Option	PORT= rfc_server_port Indicates the port number of the SAS RFC Server to use to connect to the SAP system. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
R3NAME= LIBNAME Option	R3NAME= system_name Indicates the name of the R/3 system. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
REREAD_EXPOSURE= LIBNAME Option	REREAD_EXPOSURE= NO \| YES Specifies whether the SAS/ACCESS engine behaves like a random-access engine for the scope of the LIBNAME statement. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
RFC_STRING= LIBNAME Option	RFC_STRING= additional_rfc_options Indicates additional logon or connection parameters for the RfcOpenEx() call. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
SAPLOGON_ID= LIBNAME Option	SAPLOGON_ID= saplogon_id Indicates the string that is defined for SAPLOGON on 32-bit Windows. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
SPOOL= LIBNAME Option	SPOOL= YES \| NO Specifies whether SAS creates a utility spool file during read transactions that read data more than once. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
SYSNR= LIBNAME Option	SYSNR= system_number Indicates the SAP system number—the 2-byte code that identifies the system on the host. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
TRACE= LIBNAME Option	TRACE= 0 \| 1 \| Y \| N Indicates whether SAS should trace the RFC requests. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
USER= LIBNAME Option	USER= user Indicates the SAP logon parameter user. Product: SAS/ACCESS Interface to R/3 Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide