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;
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.