ACCESS Procedure Reference

Invoking the ACCESS Procedure

To invoke the ACCESS procedure you use the options described in Options for the ACCESS Procedure and certain procedure statements. The options and statements that you choose are determined by your task.

To create an access descriptor, you use the following syntax:

PROC ACCESS DBMS=ADABAS;

CREATE libref.member-name.ACCESS;

required database-description statements;

optional editing statements;

RUN;

To create an access descriptor and a view descriptor in the same procedure, you use the following syntax:

PROC ACCESS DBMS=ADABAS;

CREATE libref.member-name.ACCESS;

required database-description statements;

optional editing statements;

CREATE libref.member-name.VIEW;

SELECT item-list;

optional editing statements;

RUN;

To create a view descriptor from an existing access descriptor, you use the following syntax:

PROC ACCESS DBMS=ADABAS ACCDESC=libref.access-descriptor;

CREATE libref.member-name.VIEW;

SELECT item-list;

optional editing statements;

RUN;
To update an access descriptor, you use the following syntax:

PROC ACCESS DBMS=ADABAS;

UPDATE libref.member-name.ACCESS;

procedure statements;

RUN;
To update a view descriptor, you use the following syntax:

PROC ACCESS DBMS=ADABAS;

UPDATE libref.member-name.VIEW;

procedure statements;

RUN;

See ACCESS Procedure Syntax for ADABAS for a listing of database description and editing statements. For information to help you code efficient descriptor files, see Additional Topics About the ACCESS Procedure.

Note that when you update an access descriptor (for example, drop another field from the display), the view descriptors based on this access descriptor are not updated automatically. You must re-create or modify any view descriptors that you want to reflect the changes made to the access descriptor. Altering a DBMS table can invalidate both access descriptors and view descriptors.

Top of Page