DISPLAY and PUNCH Syntax › DISPLAY/PUNCH SCHEMA

DISPLAY/PUNCH SCHEMA

The DISPLAY/PUNCH SCHEMA statement displays or punches an SQL schema in the dictionary.

Authorization

To issue a DISPLAY/PUNCH SCHEMA statement, you must have the DISPLAY privilege on the requested SQL schema.

Syntax

►►─┬─ DISplay ─┬──── SCHema name ──┬────────────────────┬─────────────────────►
   └─ PUNch ───┘                   ├─ FULl ─┬──┬────────┤
                                   └─ ALL ──┘  └PHYsical┘

 ►─┬──────────────────────────────────────────────────────────────────┬───────►
   └──┬─ WITh ─────────┬──┬─ ALL ───────────────┬─┬─ AS COMments ◄──┬─┘
      ├─ ALSo WITh ────┤  ├─ NONe ──────────────┤ └─ SYNtax ────────┘
      ├─ WITHOut ──────┤  ├─ DETails ───────────┤
      └─ ALSo WITHOut ─┘  ├─ HIStory ───────────┤
                          ├─ CALC keys ─────────┤
                          ├─ CONstraints ───────┤
                          ├─ INDexes ───────────┤
                          ├─ KEYs ──────────────┤
                          ├─ PROcedures  ───────┤
                          ├─ TABles ────────────┤
                          ├─ TABle PROcedures ──┤
                          ├─ VIEws ─────────────┤
                          └─ TIMestamp ─────────┘

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

Parameters

SCHema name

Specifies the SQL schema to display or punch.

Schema-name must be the name of the an SQL schema in the dictionary.

FULl or ALL

Directs CA IDMS to display all attributes of the schema except physical attributes.

PHYsical

Directs CA IDMS to display all attributes of the schema including its physical attributes. This includes table IDs, index IDs, and synchronization timestamps for functions, procedures, tables, table procedures, and views.

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 SQL schema-specific descriptions.

HIStory

Specifies the display of the chronological account of an entity's existence, including PREPARED/REVISED BY specifications, date created, and date last updated.

CALC keys

Specifies the display of all CALC keys associated with the requested SQL schema.

CONstraints

Specifies the display of all constraints associated with the requested SQL schema.

INDexes

Specifies the display of all indexes associated with the requested SQL schema.

KEYs

Specifies the display of all table procedure keys associated with the requested SQL schema.

TABles

Specifies the display of all tables associated with the requested SQL schema.

TABle PROcedures

Specifies the display of all table procedures associated with the requested SQL schema.

VIEws

Specifies the display of all views associated with the requested SQL schema.

TIMestamp

Specifies the display of the synchronization timestamps for the schema entities.

AS COMments

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

AS SYNtax

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

VERB CREate/ALTer/DISplay/DROp/PUNch

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.