17.10 - Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)
Not all combinations of acceptable syntax are shown.
SCOPE {
  { class | cylinder | table | vproc | map } [,...] |
  ALL
}
class
CLASS {
  ( { JRNL |
      { PERMANENT | P } |
      { TEMPORARY | TEMP } |
      PSPOOL |
      SPOOL
    } [[,]...]
  ) |
  ALL
}
cylinder
{ CYLINDER | CYL } { ( cylid [[,]...] ) | cylid | ALL }
table
TABLE { ( tid [[,]...] ) | tid | ALL }
vproc
VPROC {
  vproc_number |
  ( { vproc_number | vproc_number TO vproc_number } [[,]...] ) |
  ALL
}
map
MAP { "mapname" | ( "mapname" [[,]...] ) | ALL }