SAS/ACCESS Interface to ADABAS Software

Systems Options for the ACCESS Procedure and the Interface View Engine

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 systems options. The two CSECTs are: ADBAUSE for the ACCESS procedure and ADBEUSE for the interface view engine.

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

ADBAUSE Systems Options Default Values

The following systems 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.

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.

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.

ADBEUSE Systems Options Default Values

The systems options shown in ADBEUSE Systems Options Default Values 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 Systems 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.

***ADBEUSE Systems 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.

Chapter Contents
Previous
Next
Top of Page