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

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