15.00 - ROW - Teradata Database

Teradata Database Support Utilities

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

ROW

Purpose  

The ROW command displays rows from one or more subtables. For a single subtable, ROW sets the context to those rows.

Syntax  

Note: The online help lists the row options (/P, /S, /M, /L, /H) as /rowopt. You can type the options at the beginning or end of the command.

 

Syntax Element

Description

/P

Positions to the physical rows or subtable requested. At least one physical row must be in the selected range. Nothing is displayed unless there is a problem.

Physical rows store one of several types of data, such as regular table row data or column partition data.

/S or /C

Counts the number of physical rows selected. This is the default for all subtables except the table header subtable.

/M or /I

Displays only the row header information (length, RowID, and flags).

/L or /R

Formats the row header and fields in the physical row. This option is the default for the table header subtable; however, this option is not the default formatted field display because the table header subtable has a special row format and requires special formatting.

/H

Format the row header and display the entire physical row in hexadecimal, including the row header.

tid

Specifies the subtable to display, which must include a typeandindex value.For detailed information, see “Subtable Identifiers (tids)” on page 79.

ridrange

A range of rows selected based upon row identification in the row header rather than the ordinal position within the subtable. For information on ridrange formatting, see “Rows and Row Ranges” on page 76.

The online help lists this option as rowspec [TO rowspec].

Usage Notes  

The prompt for the ROW selector is shown below:

ROW ==>

The ROW command operates on subtables. In the Teradata Database, a subtable is a collection of physical rows, and a table is a collection of subtables. The physical rows of a particular subtable may store regular data rows, index rows, table header rows, column partition values, or other types of data. Therefore, you can use the ROW command to display rows from the primary data subtable, the table header subtable, a secondary index subtable, etc. For example, to obtain a formatted display of the table header, use ROW /L x y H, 0 1 where x and y make up the tablenumber which identifies the table, and H is the typeandindex value which identifies the table header subtable. For more information on identifying tables and subtables, see “Subtable Identifiers (tids)” on page 79.

In addition to global and upper-level commands, the following lower-level commands are allowed at the ROW prompt:

  • DELETE
  • DISPLAY (without ordinalrange)
  • DROP
  • NEXT
  • PATCH
  • PREV
  • WRITE