SELECT - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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

Syntax

SELECT {
  ALL |
  ERROR |
  PROC NOD-NUM [...] |
  RESET
}
[ ERRORDATE { 'yymmdd' | 'yyyymmdd' } ] ;
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
ERRORDATE ‘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.
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 retrieves dump data with negative processor numbers.

Example: Selecting dump data for load or unload

To select dump data, type the following:

select proc 16384;

The following appears:

*** Processor selection set to list of processors.