DISPLAY and PUNCH Syntax › DISPLAY/PUNCH FUNCTION

DISPLAY/PUNCH FUNCTION

The DISPLAY/PUNCH FUNCTION statement lets you display or punch a function.

Authorization

To issue a DISPLAY/PUNCH FUNCTION statement, you must hold the DISPLAY privilege for the named function.

Syntax

►►─┬─ DISplay ┬─ FUNction  ─┬──────────────┬─ function-name ┬───────────────┬─►
   └─ PUNch ──┘             └ schema-name. ┘                └FULl┬─────────┬┘
                                                                 └PHYsical ┘

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

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

Parameters

schema-name.

Identifies the SQL schema associated with the named function.

If you do not specify schema-name, then it defaults to the current schema associated with your SQL session, if you enter the statement through the command facility or execute it dynamically.

function-name

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

FULl

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

PHYsical

Directs CA IDMS to display all attributes of the function including its physical attributes. This includes the function'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 display.

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 you specify the WITH clause.

DETails

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

TIMestamp

Specifies the display of the synchronization timestamp associated with the function.

HIStory

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

KEYs

Specifies the display of all keys associated with the requested function.

AS COMments

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

AS SYNtax

Outputs function syntax which you can edit and resubmit 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.

Example

DISPLAY FUNCTION FIN.UDF_FUNBONUS FULL PHYSICAL;