DISPLAY/PUNCH VIEW

The DISPLAY/PUNCH VIEW statement displays or punches a view.
idmscu19
The DISPLAY/PUNCH VIEW statement displays or punches a view.
Authorization
To issue a DISPLAY VIEW statement, you must either own the SQL schema where the view is defined or hold the DISPLAY privilege on the named view.
Syntax
►►─┬─ DISplay ┬─  VIEw ──┬──────────────┬─view-name────┬───────────────┬──────►    └─ PUNch ──┘          └ schema-name.─┘              └FULl┬─────────┬┘                                                             └PHYsical ┘  ►─┬───────────────────────────────────────────────────────────────┬──────────►    └──┬─ WITh ─────────┬──┬─ ALL ──────────┬───┬─ AS COMments ◄──┬─┘       ├─ WITHOut ──────┤  ├─ NONe ─────────┤   └─ SYNtax ────────┘       ├─ ALSo WITh ────┤  ├─ DETails ──────┤       └─ ALSo WITHOut ─┘  ├─ HIStory ──────┤                           └─ TIMestamp ────┘  ►─┬───────────────────────┬──────────────────────────────────────────────────►◄    └─ VERb ─┬─ CREate ◄──┬─┘             ├─ DISplay ──┤             ├─ DROp ─────┤             └─ PUNch ────┘
In IDD Record Format with COBOL Elements
►►─┬─ DISplay ─┬──── VIEW ─┬────────────────┬─ view-name ─────────────────────►    └─ PUNch ───┘           └─ schema-name. ─┘  ►─── LIKe RECord ────────────────────────────────────────────────────────────►  ►─┬──────────────────────────────────────────────────────────────────┬───────►    └──┬─ WITh ─────────┬──┬─ ALL ─────────────┬───┬─ AS COMments ◄──┬─┘       ├─ WITHOut ──────┤  ├─ null INDIcators ─┤   └─ SYNtax ────────┘       ├─ ALSo WITh ────┤  ├─ record ELEments ─┤       └─ ALSo WITHOut ─┘  └─ record SYNonyms ─┘  ►─┬───────────────────────┬──────────────────────────────────────────────────►◄    └─ VERb ─┬─ CREate ◄──┬─┘             ├─ ALTer ────┤             ├─ DISplay ──┤             ├─ DROp ─────┤             └─ PUNch ────┘
Parameters
  • VIEW
    view-name
    Specifies the name of the view to display or punch.
  • schema-name.
    Identifies the SQL schema associated with the named view.
    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 view except physical attributes.
    • PHYsical
      Directs CA IDMS to display all attributes of the view including its physical attributes. This includes the view's synchronization timestamp.
  • 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; for example, the length of a table.
  • HIStory
    Specifies the display of the chronological account of an entity's existence, including PREPARED/REVISED BY specifications, date created, and date last updated.
  • TIMestamp
    Specifies the display of the synchronization timestamp for the view.
  • AS COMments
    Outputs view syntax as comments with the characters *+ preceding the text of the statement. AS COMMENTS is the default.
  • AS SYNtax
    Outputs view syntax which can be edited and resubmitted to the command facility.
  • VERB CREate/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 columns as COBOL elements, listed for the named view. 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 view.
  • record SYNonyms
    Specifies the display of record synonyms for the record syntax for the named view.
Usage
Using the LIKE RECORD Parameter
The LIKE RECORD parameter produces IDD record syntax for the named view.
You can use this syntax to define a record definition for a view in the dictionary. CA ADS dialogs can then include it as a work record definition for the view. This same record definition can be included in a map definition.