To invoke the ACCESS procedure you use the options described
in
PROC ACCESS Statement Options and certain procedure statements. The options and statements
that you choose are defined by your task.
-
To create an access descriptor:
PROC ACCESS DBMS=IMS;
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:
PROC ACCESS DBMS=IMS;
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:
PROC ACCESS DBMS=IMS ACCDESC=
libref.access-descriptor;
CREATE libref.member-name.VIEW;
SELECT item-list;
optional
editing statements;
RUN;
-
To update an access descriptor:
PROC ACCESS DBMS=IMS;
UPDATE libref.member-name.ACCESS;
procedure statements;
RUN;
-
To update a view descriptor:
PROC ACCESS DBMS=IMS;
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.