Tài liệu SAS/ACCESS 9.1 Interface to ADABAS- P5 pptx

114 View Engine ADBEUSE System Options Default Values ￾ Appendix 1

Option Default Purpose

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.

ADBDEL N

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.

Engine authorization code:

U - authorized to perform updates.

ADBUPD U

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.

User ISN flag:

Y - user can specify ISN value when adding new

records.

ADBUISN Y

N - user cannot specify ISN values.

ADBVALL 300 ADABAS value buffer length:

Minimum value = 100.

Maximum value = 32767.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark

115

APPENDIX

2

Advanced Topics

Introduction to Advanced Topics 115

Data Set Options for ADABAS 116

Using Multiple View Descriptors 118

Deleting an ADABAS Observation 118

Adding an ADABAS Observation 118

Using a BY Key To Resolve Ambiguous Inserts 119

BY Key Examples 119

By Key Example 1 120

By Key Example 2 120

By Key Example 3 120

BY Key Considerations 121

Missing Values (Nulls) 121

Using Multiple-Value Fields in Selection Criteria 122

WHERE Clause Examples 123

WHERE Clause Example 1 123

WHERE Clause Example 2 123

WHERE Clause Example 3 124

Periodic Group Fields in Selection Criteria 124

WHERE Clause Examples 125

WHERE Clause Example 1 125

WHERE Clause Example 2 126

WHERE Clause Example 3 126

Using a SAS WHERE Clause for Selection Criteria 127

SAS WHERE Clause Conditions Acceptable to ADABAS 128

SAS WHERE Clause Conditions Not Acceptable to ADABAS 129

When a SAS WHERE Clause Must Reference Descriptor Data Fields 129

Deciding How to Specify Selection Criteria 130

View WHERE Clause 130

SAS WHERE Clause 130

Introduction to Advanced Topics

This appendix contains details about some advanced topics such as using data set

options, using multiple view descriptors, deleting and adding observations, using BY

keys, and processing null values, as well as topics pertaining to selection criteria. The

discussions supplement other portions of this document.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.

116 Data Set Options for ADABAS ￾ Appendix 2

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.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark