space
Previous Page | Next Page

Information for the Database Administrator

System Options for PROC ACCESS and the Interface View Engine


Using ADBAUSE and ADEUSE System Options

Certain values used by the ACCESS procedure and the interface view engine are stored in two CSECTs (assembler language constant sections) and automatically linked with the SAS/ACCESS software load modules as system options. The two CSECTs are: ADBAUSE for the ACCESS procedure and ADBEUSE for the interface view engine.

The system options associated with PROC ACCESS control the default values used when creating a new access descriptor. The system options associated with the interface view engine control various run-time characteristics of the engine.


ADBAUSE System Options Default Values

The following system options set default values to be used by the ACCESS procedure when you create an access descriptor. You can override the default values by specifying different values by using the NSS, ADBFILE, SYSFILE, and SECFILE statements in the ACCESS procedure.

ADBAUSE System Options Using the ACCESS Procedure
Option Default Purpose
ADBNATAP blanks NATURAL SECURITY system library identifier.
ADBNATPW blanks NATURAL SECURITY system user password.
ADBNATUS blanks NATURAL SECURITY system user identifier.
ADBSECCC blanks Security file cipher code.
ADBSECDB 0 Security file database identifier.
ADBSECFL 16 Security file number.
ADBSECPW blanks Security file password.
ADBSYSCC blanks System file cipher code.
ADBSYSDB 0 System file database identifier.
ADBSYSFL 15 System file number.
ADBSYSPW blanks System file password.


View Engine ADBEUSE System Options Default Values

The system options shown in the following table set default values to be used by the interface view engine to control various run-time characteristics. You can override some of these settings by specifying data set options in a SAS procedure.

ADBEUSE System Options Default Values
Option Default Purpose
ADBBYMD R BY key mode processing:
R - generate return code when adding a new periodic group to a record that has reached the maximum number of periodic group occurrences.
N - add a new record.
ADBDBMD M Database execution mode:
M - multi-user
S - single user
ADBDEFW 0 Default WHERE clause setting:


0 - creates a default WHERE clause for ADABAS data field formats as follows (assuming that the data field named AA is the first ADABAS descriptor file):
where (aa<=0) or aa>0 (numeric)
where aa>= " (alphanumeric blank)"
1 - creates a default WHERE clause for ADABAS data field formats as follows (assuming that the data field named AA is the first ADABAS descriptor file):
where aa=0 (numeric)
where aa= "(alphanumeric blank)"
2 - displays an error return code. A view WHERE clause or SAS WHERE clause is required when random access is desired or when performing updates.
ADBDEL N Deleting periodic group flag:
N - nulls periodic group values when (1) more than one occurrence still exists or (2) other periodic groups exist within the ADABAS file but are not represented in the view descriptor.
P - always deletes the record, regardless of the existence of periodic group fields. The P means "to prune." When ADBDEL=P, you want to remove (reduce) what is superfluous, in this case, the entire logical record.
ADBDELIM \ View WHERE clause delimiter.
ADBUPD U Engine authorization code:
U - authorized to perform updates.
R - read authorization only.
ADBFMTL 500 ADABAS format buffer length. Minimum value = 100.
ADBISNL 5000 ADABAS ISN buffer length. Minimum value = 100.
ADBMAXM 191 Maximum multiple-value occurrence number.
ADBMAXP 9 Maximum periodic group occurrence number.
ADBMINM 1 Minimum multiple-value occurrence number.
ADBRECL 7500 ADABAS record buffer length:

Minimum value = 2100.

Maximum value = 32767.

ADBSCHL 500 ADABAS search buffer length. Minimum value = 100.
ADBSPANS * View WHERE clause SPANS character.
ADBUISN Y User ISN flag:
Y - user can specify ISN value when adding new records.
N - user cannot specify ISN values.
ADBVALL 300 ADABAS value buffer length:

Minimum value = 100.

Maximum value = 32767.

space
Previous Page | Next Page | Top of Page