15.00 - FIND - Teradata Database

Teradata Database Support Utilities

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

FIND

Purpose  

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

Syntax  

Note: 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.

 

Syntax Element

Description

/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)” on page 79.

ridrange

the portion of the subtable of interest. For more 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 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” on page 63.