15.00 - DISPLAY - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

DISPLAY

Purpose  

The DISPLAY command shows a formatted display of the currently selected object or range of objects. If you specify an ordinalrange, then DISPLAY shows a related object or range.

Syntax  

Note: You can type /dispopt and /rowopt at the beginning or end of the command.

 

Syntax Element

Setting Selections

Description

/dispopt

/P
/S
/M
/L
/X
/H
/Z

Specifies the format of the display output for the selected object. The display options are dependent on the object selected and may differ from those in the saved context.

Not all display options work with all object types. For descriptions of how the display options are applied to different object types, see the command for the selected object, such as CI, WCI, DB, WREC, etc.

/rowopt

/P
/S or /C
/M or /I
/L or /R
/H

Specifies the format of the display output for the selected object. The row options are dependent on the object selected and may differ from those in the saved context.

Not all row options work with all object types. For descriptions of how the row options are applied to different object types, see the command for the selected object, such as DBROW, ROW, WDBREC, etc.

ordinalrange

 

Used to establish a new context based upon the old context, and then DISPLAY shows the objects in the new context.

The online help lists this option as rangeopt.

whereclause

 

For a WAL log record range context, a WHERE clause can be supplied to replace the current WHERE clause saved in the context. For more information, see “Specifying a WHERE clause” on page 85.

Usage Notes  

The DISPLAY command is based on the current context, which may be a row, subtable, CI, CID, DB, DBD, MI, WAL log record, WCI, WCID, WDB, WDBD, or WMI. Except for the MI and WMI contexts, DISPLAY can also be based on a range selection.

The current context is established by the previous BLK, CI, CID, DB, DBD, DISPLAY, MI, ROW, TABLE, WAL, WCI, WCID, WDB, WDBD, WMI, or WREC command. These commands save a single object or range of objects as the context. This saved context can be displayed using the SHOWDEFAULTS command. For more information, see “SHOWDEFAULTS” on page 209.

If a prior command was a WAL command, the resulting context is a WAL log record or a range of WAL log records. For the WAL all command, the context begins with the first record in the WAL log and ends with the last record in the WAL log. This differs from the TABLE command where the resulting context is a subtable rather than a row range.

You can use the ordinalrange argument of the DISPLAY command to expand the current context to a larger range of objects of the same type. Similarly, you can use ordinalrange to shrink a range to a smaller range or to a single object.

The standalone integers (without the BEG/END prefix) in an ordinalrange always refer to objects outside the current context, so that positive values refer to objects past the end of the current context, and negative values refer to objects before the beginning of the current context, thus extending the context. For more information, see “Specifying Display Ranges (ordinalrange)” on page 83.

Note: This differs from the interpretation of an ordinalrange for the TABLE or WAL command, where positive integers without the BEG/END prefix are ordinal row/record numbers, so that 1 is the first row or record. Negative integers without the BEG/END prefix are backwards displacements from the last row or record. For more information, see “TABLE” on page 214 and “WAL” on page 223.

The DISPLAY command with an ordinalrange functions similarly for a WAL log record, WDB, WDBD, WCI, or WCID context, as it does for a Row, DB, DBD, CI, or CID context. Both singular and range contexts are allowed.

If a prior command was a TABLE command which used a wildcard for the type part of the tid, the resultant context is special (nothing), and this context is not usable with the ordinalrange argument. For more information, see “TABLE” on page 214.

The whereclause for the WAL and WREC commands is applied in conjunction with the ordinalrange or wlsnrange. The whereclause is recorded in the context and remains active for subsequent DISPLAY, NEXT, and PREV commands. As the display context is expanded or contracted, DISPLAY continues to use the whereclause in the context.

The whereclause for a DISPLAY command must be appropriate to the saved context, or the DISPLAY command is rejected. For example, a whereclause is not allowed with a WCI context. For more information about the whereclause, see “Specifying a WHERE clause” on page 85.