DISPLAY and PUNCH Syntax › DISPLAY/PUNCH TABLE

DISPLAY/PUNCH TABLE

The DISPLAY/PUNCH TABLE statement displays or punches the definition of a base table from the dictionary.

Authorization

To issue a DISPLAY/PUNCH TABLE statement, you must either own or have the DISPLAY privilege on the named table.

Syntax

►►─┬─ DISplay ┬─ TABle ──┬──────────────┬─ table-name ──┬───────────────┬─────►
   └─ PUNch ──┘          └ schema-name. ┘               └FULl┬─────────┬┘
                                                             └PHYsical─┘

 ►─┬───────────────────────────────────────────────────────────────┬──────────►
   └──┬─ WITh ─────────┬──┬─ ALL ──────────┬───┬─ AS COMments ◄──┬─┘
      ├─ WITHOut ──────┤  ├─ NONe ─────────┤   └─ SYNtax ────────┘
      ├─ ALSo WITh ────┤  ├─ DETails ──────┤
      └─ ALSo WITHOut ─┘  ├─ HIStory ──────┤
                          ├─ CALc keys ────┤
                          ├─ COLumns ──────┤
                          ├─ CONstraints ──┤
                          ├─ INDexes ──────┤
                          ├─TIMestamp ─────┤
                          └─VIEws ─────────┘

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

In IDD Record Format with COBOL Elements

►►─┬─ DISplay ─┬──── TABle ─┬────────────────┬─ table-name ───────────────────►
   └─ PUNch ───┘            └─ schema-name.──┘

 ►─── LIKe RECord ────────────────────────────────────────────────────────────►

 ►─┬──────────────────────────────────────────────────────────────────┬───────►◄
   └──┬─ WITh ─────────┬──┬─ ALL ─────────────┬───┬─ AS COMments ◄──┬─┘
      ├─ WITHOut ──────┤  ├─ null INDIcators ─┤   └─ SYNtax ────────┘
      ├─ ALSo WITh ────┤  ├─ record ELEments ─┤
      └─ ALSo WITHOut ─┘  └─ record SYNonyms ─┘

Parameters

TABle table-name

Specifies the name of the table to display or punch. table-name must be the name of a table defined in the dictionary.

schema-name.

Identifies the SQL schema associated with the named table.

If you do not specify 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.

FULl

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

PHYsical

Directs CA IDMS to display all attributes of the table including physical attributes. This includes the table's synchronization timestamp and table ID.

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

NONe

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

DETails

Specifies the display of table-specific descriptions; for example, the length of a table.

HIStory

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

CALc keys

Specifies the display of a CALC key associated with the requested table occurrence.

COLumns

Specifies the display of all columns associated with the requested table occurrence.

CONstraints

Specifies the display of all constraints where the requested table occurrence has been named.

INDexes

Specifies the display of all indexes associated with the requested table occurrence.

TIMestamp

Specifies the display of the synchronization timestamp for the table.

VIEws

Specifies the display of all views where the requested table occurrence participates.

AS COMments

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

AS SYNtax

Outputs table 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.

With COBOL Elements Parameters

LIKe RECord

Specifies that you want IDD RECORD syntax, with its COBOL elements, listed for the named table. For sample uses, see "Usage" later in this section.

null INDIcators

Specifies the display of COBOL elements defining NULL indicators for nullable columns.

record ELEments

Specifies the display of elements for the record syntax for the named table.

record SYNonyms

Specifies the display of record synonyms for the record syntax for the named table.

Usage

Using the LIKE RECORD Parameter

You can use the LIKE RECORD parameter to produce IDD record syntax for a named table, and then add the record syntax to a dictionary.

With the IDD record syntax for a table in the dictionary, CA ADS dialogs can include a work record definition for the table. This same record definition can be included in a map definition.