Syntax - Advanced SQL Engine - Teradata Database

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 }