DISPLAY and PUNCH Syntax › DISPLAY/PUNCH ACCESS MODULE

DISPLAY/PUNCH ACCESS MODULE

The ACCESS MODULE, DISPLAY/PUNCH statement displays or punches an access module.

Authorization

To issue a DISPLAY/PUNCH ACCESS MODULE statement, you must have the DISPLAY privilege on the requested access module.

Syntax

►►─┬─ DISplay ─┬┬─ ACCess MODule is ─┬┬───────────────┬─ access-module-name ──►
   └─ PUNch ───┘└─ AM ───────────────┘└─ schema-name.─┘

 ►─┬──────────────────────────────────┬───────────────────────────────────────►
   └─ Version ──┬─ 1 ◄──────────────┬─┘
                ├─ version-number ──┤
                ├─ HIGhest ─────────┤
                └─ LOWest ──────────┘

 ►─┬─────────────────────────────────────────────────────────────────────┬────►
   └──┬─ WITh ─────────┬──┬─ ALL ───────────────┬─── AS ─┬─COMments ◄──┬─┘
      ├─ ALSo WITh ────┤  ├─ NONe ──────────────┤        └─ SYNtax ────┘
      ├─ WITHOut ──────┤  ├─ DETails ───────────┤
      └─ ALSo WITHOut ─┘  ├─ HIStory ───────────┤
                          └─ TABles ────────────┘

 ►─┬───────────────────────┬──────────────────────────────────────────────────►◄
   └─ VERb ─┬─ CREate ◄──┬─┘
            ├─ ALTer ────┤
            └─ DROp ─────┘

Parameters

schema-name.

Specifies the schema for the access module. Schema-name must identify the schema associated with the version of the access module being modified. If ou do not specify schema-name, the value used by the command facility is the current schema for your SQL session.

access-module-name

Specifies the name of the access module to display or punch. Access-module-name must identify an access module defined and stored in the dictionary.

Version is version-number

Specifies the version number of the access module. Version-number is a unique integer in the range 1 through 9999. 1 is the default.

HIGhest

Specifies the highest version number associated with the access module.

LOWest

Specifies the lowest version number associated with the access module.

WITh

Lists the requested information, in addition to the information that is always included, such as the entity occurrence name.

WITHOut

Does not list the specified options. Other options in effect through the WITH or ALSO WITH clauses in the current DISPLAY statement are displayed.

ALSo WITh

Lists the requested information, in addition to the information requested in previously issued DISPLAY WITH and DISPLAY ALSO WITH statements for the named entity.

ALSo WITHOut

Does not list the specified options.

ALL

Specifies the display of all the information associated with the requested entity occurrence.

NONe

Specifies the display of the name of the requested entity occurrence. NONE is meaningful only when the WITH clause is specified.

DETails

Specifies the display of entity-specific descriptions.

HIStory

Specifies the display of the date the access module was compiled.

TABles

Specifies the display of all tables associated with the requested access module.

AS COMments

Outputs access module syntax as comments with the characters *+ preceding the text of the statement. AS COMMENTS is the default.

AS SYNtax

Outputs access module syntax which can be edited and resubmitted to the command facility.

VERB CREate/ALTer/DROp

Specifies the verb with which the entity statement is to be displayed or punched. For example, if VERB CREATE is specified, the output of the DISPLAY/PUNCH statement is a CREATE statement; if VERB ALTER is specified, the output is an ALTER statement; and so on. The default is VERB CREATE.