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
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

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'.