Chapter Contents


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

Data Set Options

Data set options allow you to override some of the run-time options that are stored in view descriptors. There are no LIBNAME options.

Here is a list of available data set options.
DDBKEY= 'default-key'
DDBPW= 'password'
DDBSV= 'status/version'
DDBURT= 'User-Requirements-Table-name'
DDBUSER= 'userid'

You can specify the data set options with the DATA= argument in any PROC statement or DATA step. They are effective for that single execution of the procedure. Data set options will override the corresponding values stored in the view descriptor.

The following example executes the FSEDIT procedure using a view descriptor named CUSTM. The data set options specified in the PROC statement will set the userid to JOHN and the password to MINE, regardless of what userid and password may have been included in the view descriptor.

proc fsedit data=vlib.custm (ddbuser='john' ddbpw='mine');

A description of each data set option follows.

DDBKEY= Data Set Option


The DDBKEY= data set option allows you to override the Default Key specified in the view descriptor. You must specify a CA-DATACOM/DB short name for the key that you want to use.

DDBLOAD= Data Set Option


The DDBLOAD= data set option allows you to specify a fast-loading process. DDBLOAD=0 is the default, which causes the software to reposition when adding new records. Setting DDBLOAD to a non-zero value, for example, DDBLOAD=1, avoids the processing time needed to reposition on records when it is not necessary. For example, executing the APPEND procedure with the DDBLOAD = 1 would decrease processing time.

Do not set DDBLOAD equal to 1 for SAS procedures such as FSEDIT that reposition on a newly added data record.

DDBLOCK= Data Set Option


The DDBLOCK= data set option is another way to give a procedure static data. DDBLOCK=0 (the default) causes the interface to create an intermediate file (spool file), which holds the data to be processed by the SAS program. If DDBLOCK is non-zero, for example, DDBLOCK=1, the interface view engine does not build a spool file; it assumes that only one user is accessing the table or that the table is locked by some method separate from the SAS System. For more information about member-level locking and spool files, see Locks and the Spool File.

DDBPW= Data Set Option


The DDBPW= data set option specifies an optional CA-DATADICTIONARY password. If one is specified in the view descriptor, this data set option overrides it. If CA-DATADICTIONARY requires a password and the view descriptor does not include one, you must specify the password with the DDBPW= data set option.

Not every userid requires a password. The value is the 12-character PASSWORD attribute of the PERSON entity-occurrence for the specified userid.

DDBSV= Data Set Option


The DDBSV= data set option specifies the status and version of the CA-DATACOM/DB table you want to access. Status/version is a 4-character field. A status is either PROD, TEST, or T (for TEST) plus a 3-digit number. The default is PROD. Other status values, such as HIST, are not allowed. Status/version can be changed any time.

DDBTRACE= Data Set Option


The DDBTRACE= data set option is used to analyze problems in SAS software. It also allows you to display the WHERE clause that is passed to CA-DATACOM/DB, and a message indicating whether a temporary index will be created. The default for DDBTRACE is 0, which means no information is displayed. (For more information on the WHERE clause display, see Error Messages and Debug Information.)

The DDBTRACE= data set option can be used to produce traces for debugging purposes. Contact Technical Support at the Institute if you need more information.

DDBURT= Data Set Option


The DDBURT= data set option specifies the URT that will be used by the interface view engine when it opens the view descriptor. The interface view engine will create a default URT unless you stored one as a system option, included one in the view descriptor, or specified one with the DDBURT= data set option in the SAS program.

DDBUSER= Data Set Option


The DDBUSER= data set option specifies the CA-DATADICTIONARY userid. The userid is required. If you specify this data set option, it overrides the userid in the view descriptor.

The userid is the 32-character entity-occurrence name of a PERSON entity in the CA-DATADICTIONARY database. It is not necessarily the same as the user's TSO id. The userid and optional password must have retrieval authority on six entity-types: DATABASE, FILE, RECORD, KEY, ELEMENT, and FIELD.

Chapter Contents



Top of Page

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