Overview
Use Remote connection options when creating a caslib that requires connection to a SAS Data Agent server. Include the RemoteDriverConnections parameter in your statement and configure options as needed. For example, if specifying the following options in a connection string "LOGIN_TIMEOUT=10;COMPRESS=1;", the driver waits 10 seconds for a response before disconnecting and data compression is set at the fastest allowed.
The remote driver does not implement any data set options. Therefore, all data set options are sent to SAS Data Agent as is, without modification.
Connection String Options
SERVER= <hostname>
The host name of the SAS Data Agentserver. (Required) PORT= <port-number>
Specifies the port number for SAS Data Agent. (Required) CONOPTS= <(connection-string>
The connection string to pass to SAS Data Agent for the underlying connection.
UID= <user-name>
The user name to use when connecting to SAS Data Agent.
PWD= <user-password>
The password to use when connecting to SAS Data Agent.
TOKEN= <OAuth-token>
The OAuth token to use when connecting to SAS Data Agent.
CON_TIMEOUT | CTO= <connection-timeout-in-seconds>
This option specifies the number of seconds the REMFS driver should wait when performing a non-Statement call (except for DriverConnect, which uses LOGIN_TIMEOUT). The default is 0.
LOGIN_TIMEOUT | LTO= <login-timeout-in-seconds>
This option specifies the number of seconds the REMFS driver should wait when performing a TKTSDriverConnect call. The default is 0.
RECEIPTRETRY= <Y|N|T|F|0|1>
If the remote driver times out waiting for a response from the server or a socket closes, it reconnects and attempts to get a response. The time out could be because the server never got the request, or it could be that the operation is just taking a long time. In order to determine which is the case, the RECEIPTRETRY option will ask the server to immediately send a response saying that it received the request. If the remote driver does not get the requested receipt response, it assumes that it can no longer communicate with the server and returns an error. Otherwise, the driver waits for the server to complete the operation. The default is TRUE.
MAXRETRY= <number-of-times-to-retry-a-request>
The number of times the remote driver should retry a request when it receives a timeout ‘waiting for a response’ from the server or a socket closes.
RECEIPTRETRY=TRUE is required for this option since there is no other way for the remote driver to know if the server actually received the request. The default is ‘wait forever’ as long as request receipts from the server continue.
Note: A retry means that the remote driver continues to try to get a response to the original request from the server. It does not mean that the request will be performed multiple times.
SESSION_TIMEOUT | IDLE_TIMEOUT= <session-timeout-in-seconds>
If the network connection between the client and the server closes, the server keeps the session alive for the specified time, waiting for the client to reconnect. The value 0 means use the default specified on the server. The value 1 means clean up
immediately. The default configured on the server is used if a time-out is not specified, and might also be limited by a separate maximum configured on the server.
COMPRESS= <0–6>
Specifies the amount of data compression to apply. 0=None, 1=Fastest, and 6=Smallest. Values larger than 6 are treated as Smallest. The default is 0. SSL | TLS= <(ssl-option=ssl-value;ssl-option=ssl-value;...)>
SSL Options.
PREFETCH= <x>
Enable or disable prefetch. This default is YES - prefetch enabled.
0|OFF|FALSE|NO or not specified -- turn off prefetch.
1|ON|TRUE|YES -- use default (currently 4).
[any other unsigned integer] - The maximum number of client side prefetch rowsets to cache. min is 2, max is 32, default is 4
SERVERPREFETCH= <x>
Enable/Disable server side prefetch (optional - required only if PREFETCH= has been specified).
Not specified - use PREFETCH= (client side) value.
0|OFF|FALSE|NO - disable server side prefetch (client side prefetch only).
1|ON|TRUE|YES -- use default (currently 4).
[any other unsigned integer] - The maximum number of server side prefetch rowsets to cache.
min is 2, max is 32, default is 4 PREFETCHROWS= <x>
Suggested number of rows for server side prefetch rowset.
Optional.
MIN is 10, MAX is 10K PREFETCHBYTES=x
Suggested number of bytes for server side prefetch rowset.
Optional.
MIN is 200KB, MAX is 2MB
Note: When adding a new caslib definition enable prefetch by specifying remote driver options, for example: PREFETCH=4, SERVERPREFETCH=4,
PREFETCHROWS=2000
PROXY= <(proxy-option=proxy-value;proxy-option=proxy-value;...)>
Proxy server options. Use the following PROXY OPTIONS list to configure specific names and option values for a proxy server. The default is none. This indicates the connection is made directly to the FSNET interface of SAS Data Agent.
PROXY OPTIONS
SERVER= <proxy-hostname>
The host name of the HTTP proxy to use. Required if the PROXY= connection option is specified.
PORT= <port-number>
The port number for the proxy server. Required if the PROXY= connection option is specified
UID= <user-id | username>
The user name, or ID, connecting to the proxy server.
PWD <password associated with UID>
The password for the user (UID) connecting to the proxy server.