SELECT - Advanced SQL Engine - Teradata Database

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

Syntax

SELECT {
  ALL |
  ERROR |
  RESET |
  PROC nod-num [...]
}
[ ERRORDATE { 'yymmdd' | 'yyyymmdd' | "yymmdd" | "yyyymmdd" } ] ;

Syntax Elements

ALL

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

ERROR

RESET

Load or unload operation.

Only processors with an error code are selected.

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.

yymmdd

yyyymmdd

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

yy or yyyy is the year, mm is the month, and dd is the day. For example, August 6, 2019 is 20200806 or 190806.

Dul retrieves all error records with a date equal or later than yymmdd or yyyymmdd.

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 retrieves dump data with negative processor numbers.

Example: Selecting dump data for load or unload

To select dump data, type the following:

The following appears:

*** Processor selection set to list of processors.