ACCESS Procedure Reference

CREATE (View Descriptor) Statement

Creates a view descriptor.

Required statement
Applies to:	view descriptor

Syntax
Details
Arguments

Syntax

CREATE libref.member.VIEW PSBNAME=psb-name <PCBINDEX=pcb-index>

<GSAM>;

Details

The CREATE statement specifies a one- or two-level name for the view descriptor you want to create. The suffix specifies the member type VIEW. This statement is required to create and save a view descriptor.

To create a view descriptor, add the CREATE statement after the procedure statements that create the access descriptor on which this view descriptor is based. If you are creating a view based on an existing access descriptor, specify the access descriptor's name in the ACCDESC= option in the PROC ACCESS statement.

Place any editing statement and view-descriptor-specific statements, such as the SELECT and SUBSET statements, after the view descriptor's CREATE statement. You can submit more than one CREATE statement in one execution of the PROC ACCESS statement. As with other SAS procedures, end the ACCESS procedure with a RUN statement.

When you submit a CREATE statement for processing, the statement is checked for errors and, if none are found, the view descriptor specified in the previous CREATE statement (if there is one) is saved. If errors are found, error messages are written to the SAS log and processing is terminated. After you correct the error, resubmit the statements or batch job for processing.

Arguments

The following list explains the arguments that can appear in a CREATE statement for a view descriptor:

PSBNAME= |PSB=: specifies the name of the PSB that references the IMS database on which this view descriptor is based. This is a required argument.
PCBINDEX= |PCB=: specifies the PCB in the PSB that references the database. This argument is optional; you need to specify a PCB index only if the PSB references the database more than once. If you do not specify a PCB index and the PSB references the database more than once, the first PCB in the PSB that references the database is used.
GSAM: specifies that the database on which this descriptor is based is a GSAM database. Specify this argument only if you have a GSAM database.

Top of Page