SAS/ACCESS Interface to IMS-DL/I Software

ACCESS Procedure Syntax

PROC ACCESS <options>;

Creating or Updating Statement

CREATE libref.member-name.ACCESS|VIEW;

UPDATE libref.member-name.ACCESS|VIEW;

Database-Definition Statements

DATABASE=database-name DBTYPE=database-type;

RECORD=record-name SEGMENT=segment-name
SEGLNG=segment-length;

GROUP=group-name LEVEL=level-number
KEY=Y|N|U OCCURS=number-of-repeats
SEARCH=search-name;

ITEM=item-name LEVEL=level-number
DBFORMAT=database-format
FORMAT=SAS-format SEARCH=search-name
KEY=Y|N|U OCCURS=number-of-repeats
DBCONTENT=database-content;

DELETE item-name|index-number;

INSERTitem-name|index-number;

REPLACE item-name|index-number;

Editing Statements

AN=Y|N;

UN=Y|N;

DROP item-name|index-number... ;

FORMAT item-name|index-number <=> format... ;

LIST ALL|VIEW|index-number|item-name <blanks|DB|DESC>;

QUIT;

RENAME item-name|index-number <=> SAS-name... ;

RESET ALL|item-name|index-number ... ;

SELECT ALL|item-name|index-number... ;

SUBSET selection-criteria;

RUN;

Description

The ACCESS procedure is used to create and edit access descriptors and view descriptors, and to create SAS data files. Descriptor files describe DBMS data so that you can read, update, or extract the DBMS data directly from within a SAS session or in a SAS program.

The following sections provide more information about the syntax of the PROC ACCESS statement.

PROC ACCESS Statement Options

To create and edit access and view descriptor files, you must issue the PROC ACCESS statement with options and procedure statements. The statement has this format:

PROC ACCESS <options>;

required-procedure-statements;

optional-procedure-statements;

This section describes PROC ACCESS options. For information on the procedure statements, see Procedure Statements.

Options

Depending on which options you choose, the ACCESS procedure performs several tasks. To create and edit access and view descriptors, use the following options:

DBMS=IMS

specifies the name of the database management system that the access descriptor will access. Specify DBMS=IMS since you are using the SAS/ACCESS interface to IMS-DL/I.

ACCDESC=libref.access-descriptor

specifies the name of an access descriptor.

ACCDESC= is used with the DBMS= option to create a view descriptor that is based on the specified access descriptor. You specify the view descriptor's name in the CREATE statement. You can also use a data set option on the ACCDESC= option to specify any passwords that have been assigned to the access descriptor. The access descriptor that you name must exist.

The ACCDESC= option has two aliases: AD= and ACCESS=.

The following options allow you to extract IMS-DL/I data with a view descriptor:

VIEWDESC=<libref.>view-descriptor: specifies the name of the view descriptor from which to extract the IMS-DL/I data.
OUT=<libref.>member-name: specifies the SAS data file to which DBMS data are written. OUT= is used only with the VIEWDESC= option.

CAUTION:: Altering an IMS-DL/I database invalidates descriptors. Altering an IMS-DL/I database that has descriptor files defined on it may cause these descriptors to be out-of-date or invalid. For example, if you add an item to a database segment and an existing access descriptor is defined on that database, the access descriptor does not reflect the new item.

Chapter Contents
Previous
Next
Top of Page