16.10 - FIND - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The FIND command, given the subtable and optional RowID range, displays cylinders containing the range with detail, depending on the options.

Syntax

The online help lists the display options (/S, /M, /L) as /dispopt. You can type the options at the beginning or end of the command.


/S
Displays the first CID, SRD, and DBD for range.
/M
Displays the first CID, SRD, and DBD for range, as well as all CIDs and the last SRD and DBD for range.
/L
Displays every CID, SRD, and DBD for range.
tid
the subtable of interest. For more information on tid formatting, see Subtable Identifiers (tids).
ridrange
the portion of the subtable of interest. For more information on ridrange formatting, see Rows and Row Ranges.
The online help lists this option as rowspec [TO rowspec].

Usage Notes

The range default is the entire subtable.

FIND sets the context to null.

If Filer is invoked from the Coroner mode of the debugger, gdb, the FIND command works in a limited manner, displaying whatever is found in the dump. For information on invoking Filer from the Coroner, see Running Filer from the System Debugger and Coroner.