Libname Options Syntax Listed by Product

SAS/ACCESS

A B C D E F I K L M O P Q R S T U

Name
Syntax and Description
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=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=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= 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= 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=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=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=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= 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=<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= '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=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=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=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=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= < 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=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= 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=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= 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= 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=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=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= 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= 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=<'>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=<'>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='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=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=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=<'>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=<'>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= 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=<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=YES | NO
Specifies whether SAS creates temporary or permanent tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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=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=COMPAT | NONE
Specifies the column labels an engine uses.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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=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=YES| NO
Specifies when the connection to the DBMS occurs.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DEGREE=ANY | 1
Determines whether DB2 uses parallelism.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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=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=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=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=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= 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=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=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=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=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= '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=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= 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=<'>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= 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= location
Allows further qualification of exactly where a table resides.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOCKTABLE=EXCLUSIVE | SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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=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= < 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= 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= 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=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=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=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=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=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= 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='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='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=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=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= <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=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=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= 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= 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=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= 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=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=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= 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=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=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=MEMORY | SERVER | DISK
Determines where to store query results.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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= 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=<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=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=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=<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=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=<(>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=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=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=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=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= 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= 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=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=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=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=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= 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=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=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= 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= 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= 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= 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= 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= 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 = 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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 = 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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= 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