MoveTablesSP executes a worker session that consumes and executes actions from table ActionQueueTbl, which was populated by a prior call to ManageMoveTablesSP. You can make multiple concurrent calls to MoveTableSP, where the workers fetch and perform actions in parallel from the shared queue.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
CALL [TDMaps.] MoveTablesSP ( 'ActionList', 'DatabaseName', 'TableName', 'TargetMapName', 'ColocationName' ) [;]
Syntax Elements
- TDMaps.
- The name of the database.
- ActionList
- The options are 'P' for the ParallelTableActionList, or 'S' for the SerialTableActionList.
- DatabaseName
- The database in which the object is defined.
- TableName
- Name of table, join index, or hash index defined in DatabaseName.
- TargetMapName
- Name of the map where the object is moved.
- ColocationName
- The colocation name string for the table.