The table below describes
the data service connection options for the SAS Federation Server Driver for SAP.
|
|
|
|
|
ABAPFM = abap_function_name
Specifies the name of
the Advanced Business Application Programming (ABAP) function module
that the driver uses internally. The default is /SAS/Z_SAS_DIALOG.
Alias: ABAPFUNCTION,
ABAPFUNC
|
|
|
ABAP_NAMESPACE
=namespace
Specifies the namespace
for ABAP functions and programs that are used by the driver. If the
ABAP programs are installed in the customer namespace rather than
in the default namespace, this parameter identifies where the ABAP
programs are installed. The default is /SAS/
Alias: ABAPNAMESPACE,
ABAP_NAME_SPACE, ABAPNS, ABAP_NS
|
|
|
Specifies the name of
the ABAP language that the driver uses internally. This value is set
by the ABAP function module. The default is /SAS/Z_SAS_READ.
Alias: ABAPREPORT, ABAPPROGRAM
|
|
|
ASHOST=application_server_host
Specifies the host name
of the server or IP address of a specific application server. There
is no default.
Alias: HST, RFCHOST,
R3HOST
|
|
|
Specifies whether the SAS Federation Server Driver for SAP should
use SAP batch jobs for the data extracts. If set at Y (Yes),
the SAS Federation Server Driver for SAP uses batch jobs to extract
R/3 data. When set at N (No), the SAS Federation Server Driver for SAP
uses dialog processes to extract R/3 data. The default is N (No).
Alias: BATCH_MODE, BATCHMODE
|
|
|
Sets the minimum buffer
size for data transfers in batch and dialog modes. The number of bytes
should be greater than 10,000 and no more than eight digits. The default
is 100,000 bytes.
Alias: BUFFERSIZE, BUFFSIZE,
BLOCK_SIZE, BLOCKSIZE
|
|
|
Specifies the SAP logon
parameter client. Examples for a client are 000 or 800. The default
is the SAP system default.
Note: When you access the SAP system
using the driver, specify valid logon information including CLIENT, USER
NAME, PASSWORD, and LANGUAGE.
The user ID and password can also be passed through single sign-on
(SSO). The driver performs a logon check at OPEN time.
Alias: CLI, RFCCLIENT,
RFCCLI
|
|
|
DEFAULT_ATTR=(attr=value)
Used to specify connection handle
or statement handle attributes supported for initial connect-time
configuration, where attr=value corresponds
to any of the following options:
-
CURSORS=n-
Connection handle option. This option controls the driver’s
use of client side result set cursors. The possible values are 0,
1 or 2.
| 0 |
Causes the driver to use client-side static cursor
emulation if a scrollable cursor is requested but the database server
cannot provide one.
|
| 1 |
Causes the driver to always use client-side static
cursor emulation if a scrollable cursor is requested. The database
server’s native cursor is not used.
|
| 2 |
(Default) Causes the driver to never use client-side
static cursor emulation if a scrollable cursor is requested. The database
server’s native cursor is used if available. Otherwise, the
cursor will be forward-only.
|
Example: DEFAULT_ATTR=(CURSORS=2)
-
USE_EVP=n -
Statement handle option. This option optimizes the driver for large
result sets. The possible values are 0 (OFF) or 1 (ON), which is the
default. Example: DEFAULT_ATTR=(USE_EVP=0)
-
XCODE_WARN=n -
Statement handle option. Used to warn on character transcoding errors
that occur during row input or output operations. Possible values
are 0 (returns an error), 1 (returns a warning), or 2 (ignore transaction
errors). 0 is the default. Example: DEFAULT_ATTR=(XCODE_WARN=1)
|
|
|
DESTGROUP=destination_group
Specifies the name of
the destination group for batch access to the SAP system. The destination
groups are defined in the / SAS/DESTS table in SAP. The default is SAS1.
|
|
|
Specifies the destination
in the saprfc.ini file, if working with a
saprfc.ini file. If the RFC server is an R/3 system, this destination
must also be defined in the SIDEINFO file
for the SAP gateway.
|
|
|
GROUP=application_server_group
Specifies the name of
the group of application servers for load balancing.
|
|
|
GWHOST = gateway_host_name
Specifies the host name
of the SAP gateway, if the server is R/2 or external.
|
|
|
Specifies the service
of the SAP gateway, if the server is an R/2 server or external.
|
|
|
Specifies whether floating
point numbers are byte reversed. The possible values are Y (floating-point
numbers are byte reversed) and N (floating-point numbers are not byte
reversed). The default value for an R/3 application server on Windows
NT is Y. On other platforms, the default value is N.
|
|
|
Specifies the code page.
Indicates the code page of the SAP server. The encoding is determined
by the value returned by the SAP server. In some rare cases, it might
be necessary to override this value by setting the inencoding
= connection parameter.
|
|
|
Specifies the SAP logon
parameter language. The value for language is either the 2-byte ISO-language
key or the 1-byte SAP-language. Examples for the language are EN,
DE or E, D. If not specified, the language set on the SAP system is
the default.
Note: When you access the SAP system
using the driver, specify valid logon information including CLIENT, USER
NAME, PASSWORD, and LANGUAGE.
The user ID and password can also be passed through single sign-on
(SSO). The driver performs a logon check at OPEN time.
Alias: LANG, LNG, RFCLANG,
RFCLNG
|
|
|
Specifies the number
of tables that can be used in a left outer join or an inner join in
ABAP Open SQL. The default is 25.
Alias: MAX_TABLES_JOIN,
MAX_TABLES_JOINS, MAX_TABLE_JOIN
|
|
|
MSHOST = message_server_host
Specifies the host name
of the Message Server for load balancing.
|
|
|
Specifies the name space
to be viewed with directory services. Also used to apply table filters
that limit the number of SAP namespaces returned by the SAS Federation Server Driver for SAP by
specifying multiple items in a comma-delimited string: NAMESPACE={T000,
AAA, B1}.
|
|
|
Specifies the SAP logon
parameter password.
Note: When you access the SAP system
using the driver, specify valid logon information including CLIENT, USER
NAME, PASSWORD, and LANGUAGE.
The user ID and password can also be passed through single sign-on
(SSO). The driver performs a logon check at OPEN time.
Alias: PASSWORD, PASSWD,
PW, PASS
|
|
|
Specifies the name of
the R/3 system, if load balancing is being used.
|
|
|
RFC_STRING
= additional_rfc_options
Specifies additional
logon or connection parameters for the RfcOpenEx() call.
The SAS Federation Server Driver for SAP uses the RfcOpenEx() call
to log on to the SAP system. Using this option, parameters which are
not connection attributes for the SAS Federation Server Driver for SAP,
can be passed to the RfcOpenEx call. For
example: RFC_STRING = "ABAP_DEBUG=1".
This option can be used to support future extensions of the RfcOpenEx call.
Alias: RFCSTRING, RFC_OPTIONS_EXT,
RFCOPENEX, ADDITIONAL_RFC_OPTIONS
|
|
|
SAPLOGON_ID
= saplogon_id
Specifies the string
defined for SAPLOGON on a Windows 32-bit system.
|
|
|
Specifies the SAP system
number, if load balancing is not being used. The number is the two-byte
code that identifies the system on the host, for example, 00 and 01.
Alias: SYS, SYSTEM,
SYSNO
|
|
|
Specifies if the SAS Federation Server Driver for SAP should
trace requests. If the trace option is set to 1 or Y,
the driver writes log information into a file. The RFC library logs
messages in the dev_rfc file. The default
setting is 0 ( N), RFC
trace is off.
Note: The RFC trace directory is
set using the RFC_TRACE_DIR environment variable.
|
|
|
Specifies the SAP logon
parameter user.
Note: When you access the SAP system
using the driver, specify valid logon information including CLIENT, USER
NAME, PASSWORD, and LANGUAGE.
The user ID and password can also be passed through single sign-on
(SSO). The driver performs a logon check at OPEN time.
Alias: USR, USER, RFCUSER,
USERNAME, USERID
|