|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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 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=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
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
|
|
|
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 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
|
|
|
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 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
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
|
|
|
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=
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
|
|
|
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
|
|
|
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
|
|
|
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 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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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=
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
|
|
|
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
|
|
|
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
|
|
|
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
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
|
|
|
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
|
|
|
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
|
|
|
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=
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
|
|
|
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
|
|
|
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
|
|
|
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
|