Tài liệu SAS/ACCESS 9.1 Interface to ADABAS- P3 ppt

54

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

55

CHAPTER

5

ACCESS Procedure Reference

Introduction to ACCESS Procedure Reference 55

Case Sensitivity in the ACCESS Procedure 56

ACCESS Procedure Syntax for ADABAS 56

Description 57

PROC ACCESS Statement Options 58

SAS Passwords for SAS/ACCESS Descriptors 58

Assigning Passwords 59

Assigning Passwords with the DATASETS Procedure 59

Invoking the ACCESS Procedure 60

ACCESS PROCEDURE Statements for ADABAS 61

WHERE Clause in an ADABAS View Descriptor 88

View WHERE Clause Syntax 88

View WHERE Clause Examples 89

Specifying Conditions with the SPANS Operator 90

Specifying Expressions 90

Specifying Values in Character Fields 90

Specifying Numeric Format Values 90

Specifying Dates 91

Specifying Values in Superdescriptor Fields 91

Specifying Values in Subdescriptor Fields 92

Specifying Values in Multiple-Value Fields 93

Specifying Values in Periodic Group Fields 93

SORT Clause in a View Descriptor 93

View SORT Clause Syntax 93

SORT Clause Examples 94

Creating and Using ADABAS View Descriptors Efficiently 94

ACCESS Procedure Formats and Informats for ADABAS 95

Effects of the SAS/ACCESS Interface on ADABAS Data 97

Introduction to ACCESS Procedure Reference

The ACCESS procedure enables you to create and edit descriptor files that are used

by the SAS/ACCESS interface to ADABAS. This section provides reference information

for the ACCESS procedure statements, including procedure syntax and statement

options.

Additionally, the following sections provide information to help you optimize the use

of the interface:

￾ “Creating and Using ADABAS View Descriptors Efficiently” on page 94 presents

efficiency considerations for using the SAS/ACCESS interface to ADABAS.

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

56 Case Sensitivity in the ACCESS Procedure ￾ Chapter 5

￾ “ACCESS Procedure Formats and Informats for ADABAS” on page 95 summarizes

how the SAS/ACCESS interface converts each type of ADABAS data into its

equivalent SAS variable format.

￾ “Effects of the SAS/ACCESS Interface on ADABAS Data” on page 97 explains how

the SAS/ACCESS interface handles specific ADABAS data fields.

If you need help with SAS data sets and data libraries, their naming conventions, or

any terms used in regard to the ACCESS procedure, refer to the SAS Language

Reference: Dictionary and the SAS Companion for z/OS.

Case Sensitivity in the ACCESS Procedure

SAS names are not case sensitive; they can be entered in either uppercase or

lowercase. The ACCESS procedure converts DBMS column names to uppercase

including names enclosed in quotation marks. Any DBMS names that contain special or

national characters must be enclosed in quotation marks.

ACCESS Procedure Syntax for ADABAS

PROC ACCESS <options>;

Creating and Updating Statements

CREATE libref.member-name.ACCESS | VIEW;

UPDATE libref.member-name.ACCESS|VIEW <password-level=SAS-password>;

Database-Description Statements

DDM = data-definition-module-name;

NSS (LIBRARY | LIB= library-identifier

USER= user-identifier

PASSWORD | PW= Natural-Security-password);

ADBFILE (NUMBER | NUM= Adabas-file-number

PASSWORD | PW= Adabas-password

CIPHER | CC= Adabas-cipher-code

DBID= Adabas-database-identifier);

SYSFILE (NUMBER | NUM= Adabas-system-file-number

PASSWORD | PW= Adabas-password

CIPHER | CC= Adabas-cipher-code

DBID= Adabas-database-identifier);

SECFILE (NUMBER | NUM= Natural-Security-system-file-number

PASSWORD | PW= Adabas-password

CIPHER | CC= Adabas-cipher-code

DBID= Adabas-database-identifier);

Editing Statements

ASSIGN <=> YES | NO | Y | N;

CONTENT column-identifier-1 <=> SAS-date-format | length | E

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