Information for the Database Administrator

System Options for PROC ACCESS 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 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.

Top of Page