15.00 - SELECT - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SELECT

Purpose  

The SELECT command sets criteria determining the dump data selected for a load or unload operation.

Syntax  

 

Syntax element …

Is the …

ERROR

load or unload operation.

Only processors with an error code are selected.

RESET

same as ERROR.

PROC  NOD-NUM

unload operation.

NOD-NUM specifies the number of the virtual processor to be selected. Dump data will be loaded or unloaded only from this node. Valid values for NOD-NUM are 30720 and greater.

ALL

load or unload operation select dump data from all processors. This is the default.

ERRORDATE ‘yymmdd’ or

‘yyyymmdd’

error date to be selected from the DBC.SW_EVENT_LOG table.

The ‘yymmdd’ or ‘yyyymmdd’ represents the year, month, and day, respectively. Dul retrieves all error records with a date equal or later than the yymmdd or yyyymmdd specification.

Note: You can enclose the date in either apostrophes or double quotation marks.

Usage Notes  

You must always type the SELECT command before you type an UNLOAD command. If you do not specify a SELECT command, the entire dump is selected.

Negative processor numbers are used for special record types. When RESET is specified, dul and dultape retrieve dump data with negative processor numbers.

Example  

To select dump data, type the following:

select proc 16384;

The following appears:

*** Processor selection set to list of processors.