SAS/ACCESS Interface to CA-DATACOM/DB: Reference

System Options

SAS system options for the CA-DATACOM/DB interface are specified the same way as other SAS system options. The CA-DATACOM/DB options are invocation options. Therefore, you can specify the options in a configuration file, in the DFLTOPTS table, or when you invoke the SAS System. They cannot be changed during the SAS session.

Several system options (for example, DDBDBN=, DDBPW=, DDBUSER=, and DDBSV=) can also be specified as data set options. A data set option value can override a system option for the duration of a single procedure or DATA step. See Data Set Options for more information about data set options.

Several system options control the default values used when creating a new access descriptor. You can override the default values by specifying different values in the ACCESS procedure or by setting the appropriate values to the options. Here are some examples of setting system options for the interface:

DDBDBN=INVENTORY
DDBLOAD=1

The first system option sets INVENTORY to be the CA-DATACOM/DB database name. The second system option requests the CA-DATACOM/DB engine to keep track of the number of inserts to the database.

Another useful system option is DDBUPD. This option specifies whether the interface view engine is allowed to perform updates against the CA-DATACOM/DB tables. The value Y allows updates; the value N allows read-only access. When the value is N, any attempt to update a CA-DATACOM/DB table is rejected and an error message is written to the SAS log. The default value is Y.

Note: In previous releases of SAS/ACCESS interface to CA-DATACOM/DB, DDBUPD was called DDBENGMD. [cautionend]

Once your SAS session is executing, you can display the values of system options by entering the following SAS statements:

proc options ddb;
run;

The system options for the SAS/ACCESS interface to CA-DATACOM/DB are written to the SAS log. Note that you cannot see the options for any passwords.

For convenience, you may want to set certain options during installation rather than with each SAS invocation. In addition, you may want to restrict certain options so they cannot be changed for a SAS session. You do this by specifying their values in the Restricted Options Table during installation. Refer to the installation instructions for details.

The CA-DATACOM/DB system options are listed in CA-DATACOM/DB System Options.

CA-DATACOM/DB System Options
Systems Option Default Purpose

DDBDBN blanks Database name

DDBPW blanks Password for CA-DATADICTIONARY

DDBSV PROD Status/Version

DDBURT blanks User Requirements Table to be used

DDBUSER blanks Userid for CA-DATADICTIONARY

DDBDELIM \ Changes the delimiter

DDBUPD
(formerly DDBENGMD)
0 Engine mode (update or read-only)

DDBLOAD 0 Mode for loading data records

DDBLOCK 0 Spooling mechanism

DDBMASK # Changes the mask character

DDBMISS blank Sets missing values to blanks or X'00

DDBSPANS * Changes the SPANS character

DDBTASK 2 Number of concurrent tasks

DDBTRACE 0 Displays WHERE clauses and debug traces

***CA-DATACOM/DB System Options***
Systems Option	Default	Purpose
DDBDBN	blanks	Database name
DDBPW	blanks	Password for CA-DATADICTIONARY
DDBSV	PROD	Status/Version
DDBURT	blanks	User Requirements Table to be used
DDBUSER	blanks	Userid for CA-DATADICTIONARY
DDBDELIM	\	Changes the delimiter
DDBUPD (formerly DDBENGMD)	0	Engine mode (update or read-only)
DDBLOAD	0	Mode for loading data records
DDBLOCK	0	Spooling mechanism
DDBMASK	#	Changes the mask character
DDBMISS	blank	Sets missing values to blanks or X'00
DDBSPANS	*	Changes the SPANS character
DDBTASK	2	Number of concurrent tasks
DDBTRACE	0	Displays WHERE clauses and debug traces

Chapter Contents
Previous
Next
Top of Page