Chapter Contents


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:


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;

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
DDBSV PROD Status/Version
DDBURT blanks User Requirements Table to be used
DDBDELIM \ Changes the delimiter

(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



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.