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.