Advanced Topics

Data Set Options for ADABAS

In order for the ADABAS interface view engine to obtain ADABAS dictionary information, it needs certain ADABAS information. Specifically, the engine needs either a NATURAL DDM name or an ADABAS file number, in addition to a library identifier, a user identifier, passwords, cipher codes, and a database identifier.

If any of this information is required to access an ADABAS file or a NATURAL DDM but is not specified in the SAS/ACCESS view descriptor or cannot be obtained from either the ADBEUSE or ADBAUSE CSECT, you must use the appropriate data set option in your SAS procedure statement to supply the appropriate value.

Data set options enable you to specify these values. Data set options also enable you to override certain values that are specified in view descriptors but not enforced by ASSIGN SECURITY=YES.

Each data set option is an option in the DATA= specification where DATA= specifies a view descriptor that will be used as input to a SAS procedure. Data set options apply only for the duration of that procedure.

The following example executes the FSEDIT procedure using a view descriptor named VLIB.USAINV. The data set option specified in the PROC statement will execute ADABAS using the NATURAL SECURITY password INVOICE.

proc fsedit data=vlib.usainv (adbnatpw='invoice'};
run;

The available data set options appear below. Options marked with an asterisk (*) are enforced by ASSIGN SECURITY=YES. That is, if ASSIGN SECURITY=YES, the values specified in the view descriptor take precedence over values specified with a data set option; the data set option is ignored.

ADBCC='cipher-code'

specifies a cipher code for the target ADABAS file.

ADBDBID=database-identifier

specifies a database identifier for the target ADABAS file.

ADBDEL=N|NO|Y|YES

enables you to override the default value for the interface view engine's system option that determines whether a record containing periodic group fields should be completely deleted or its periodic group fields set to nulls. The default is set by the ADBDEL systems option in the ADBEUSE CSECT.

NO means set the fields to null; YES means delete the entire record.

ADBDDM='ddm-name'

specifies a NATURAL Data Definition Module (DDM) name. The ADBFILE and ADBDDM data set options are mutually exclusive. If you specified a DDM name in the view descriptor, you can use ADBDDM, but you cannot use ADBFILE. If you specified an ADABAS file number instead, you can use ADBFILE but not ADBDDM.

ADBFILE=file-number

specifies an ADABAS file number. The ADBFILE and ADBDDM data set options are mutually exclusive. If you specified a DDM name in the view descriptor, you can use ADBDDM, but you cannot use ADBFILE. If you specified an ADABAS file number instead, you can use ADBFILE but not ADBDDM.

ADBFMTL=length

specifies the length for the ADABAS format buffer. The minimum value is 100. The default value is 500.

ADBISNL=length

specifies the length for the ADABAS ISN buffer. The minimum value is 100. The default value is 5,000.

ADBL3=N|NO|Y|YES |O|ONLY

controls the use of the ADABAS L3 command by the interface view engine and what commands are used when L3 cannot be used. The L3 command optimizes WHERE and sort processing, with dramatic results for very large ADABAS files. However, there are limitations on when the command can be used. See Retrievals with Only a WHERE Clause for more information.

NO means the L3 command should not be used; YES means that L3 is used and S1 and S9 are used if L3 cannot be used; ONLY means that L3 is used and S2 is used, or an error is generated, when L3 cannot be used.

ADBNATAP='library-id' *

specifies a NATURAL SECURITY library identifier.

ADBNATPW='password' *

specifies a NATURAL SECURITY user password.

ADBNATUS='user-id' *

specifies a NATURAL SECURITY user identifier.

ADBPW='password' *

specifies an ADABAS password for the target ADABAS file.

ADBRECL=length

specifies the length for the ADABAS record buffer. Acceptable values are in the range of 2,100-32,767. The default value is 7,500.

ADBSCHL=length

specifies the length for the ADABAS search buffer. The minimum value is 100. The default value is 500.

ADBSECCC='cipher-code' *

specifies an ADABAS cipher code for the NATURAL SECURITY system file.

ADBSECDB=database-identifier

specifies an ADABAS database identifier for the NATURAL SECURITY system file.

ADBSECFL=file-number

specifies an ADABAS file number for the NATURAL SECURITY system file.

ADBSECPW='password' *

specifies an ADABAS password for the NATURAL SECURITY system file.

ADBSYSCC='cipher-code' *

specifies an ADABAS cipher code for the DDM system file.

ADBSYSDB=database-identifier

specifies an ADABAS database identifier for the DDM system file.

ADBSYSFL=file-number

specifies an ADABAS file number for the DDM system file.

ADBSYSPW='password' *

specifies an ADABAS password for the DDM system file.

ADBTRACE=option

specifies a trace option, which analyzes problems in SAS software. The default is ADBTRACE=0. If you specify ADBTRACE=1, WHERE clauses are displayed in the log. For more information about ADBTRACE, see Debugging Information for ADABAS.

ADBVALL=length

specifies the length for the ADABAS value buffer. Acceptable values are in the range of 100-32,767. The default value is 300.

Top of Page