ManageMoveTablesSP | SQL Operators & User-Defined Functions | Teradata Vantage - 17.10 - ManageMoveTablesSP - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-08-13
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval

Moves a group of tables within a certain time limit out of the ActionsTbl and into the ActionQueueTbl queue table.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Syntax

CALL [TDMaps.] ManageMoveTablesSP (
  ['JobNumber',]
  'SerialTableActionList',
  'ParallelTableActionList',
  { 'TimeLimit' | NULL },
  'GroupActions',
  :ActionsCompleted,
  :NumErrors,
  :TimeExpired
) [;]

Syntax Elements

TDMaps.
The name of the database.
JobNumber
An optional job number recorded in the history table.
SerialTableActionList
Named list of table actions to perform by only one session.
ParallelTableActionList
Named list of table actions to perform by one or more sessions.
TimeLimit
Maximum time in minutes for executing actions. The valid range is 1 to 10080 (7 days). NULL indicates an unlimited duration.
GroupActions
'Y' indicates related actions are scheduled and executed in a strict grouped fashion.
'N' indicates actions within a group are scheduled and executed independently.
ActionsCompleted
The number of actions that were successfully completed.
NumErrors
The number of actions that encountered a failure.
TimeExpired
'Y' indicates the time limit was exceeded prior to completing all actions in TableActionList. Otherwise, the parameter is 'N'.