 |
|
| Information for the Database Administrator |
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. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
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 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 the following table.
| 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 | User ID for CA-DATADICTIONARY |
| DDBDELIM | \ | Changes the delimiter |
| DDBUPD | 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 |
|
|
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.