DISPLAY and PUNCH Syntax › DISPLAY/PUNCH KEY

DISPLAY/PUNCH KEY

The DISPLAY/PUNCH KEY statement displays a table procedure key definition stored in the dictionary.

Authorization

To issue a DISPLAY KEY statement, you must either own or hold the ALTER privilege on the table procedure on which the key being displayed or punched is defined.

Syntax

►►─┬─ DISplay ─┬─── KEY key-name ON ──┬────────────────┬── procedure-name ────►
   └─ PUNch ───┘                      └─ schema-name. ─┘

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

 ►─┬───────────────────────┬──────────────────────────────────────────────────►◄
   └─ VERb ─┬─ CREate ◄──┬─┘
            ├─ DISplay ──┤
            ├─ DROp ─────┤
            └─ PUNch ────┘

Parameters

key-name

Specifies the name of a key on a table procedure.

schema-name.

Identifies the schema associated with the table procedure.

If you do not specify a schema-name it defaults to the current schema associated with your SQL session, if the statement is entered through the Command Facility or executed dynamically.

procedure-name

Specifies the name of the procedure or table procedure on which the key is defined. The procedure-name must identify a procedure or table procedure defined in the dictionary.

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

ALSo WITHOut

Does not list the specified options.

ALL

Specifies the display of all the information associated with the requested key.

NONe

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

DETails

Specifies the display of key-specific descriptions.

HIStory

Specifies the display of the date the key was created.

AS COMments

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

AS SYNtax

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

VERB CREate/DISplay/DROp/PUNch

Specifies the verb with which the key 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.