System Options for the CA-Datacom/DB Interface

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 SAS. 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 performs updates against the CA-Datacom/DB tables. The value Y enables updates; the value N enables 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 the SAS/ACCESS interface to CA-Datacom/DB, DDBUPD was called DDBENGMD.
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 might want to set certain options during installation rather than with each SAS invocation. In addition, you might want to restrict certain options so that they cannot be changed for a SAS session. You do this by specifying their values in the Restricted Options Table during installation. See the installation instructions for details.
The CA-Datacom/DB system options are listed in the following table.
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
DDBUSER
blanks
User ID 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