16.10 - Example: Updating ActionsTbl Row - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Published
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)
Last Update
2018-04-26

The example shows updating a row in ActionsTbl, in which the user changes the destination map to TD_Map3:

UPDATE ActionsTbl
   SET ActionSQLText = 'ALTER TABLE FSK.customer, MAP=TD_Map3',
      DestinationMap = 'TD_Map3',
      Origin = 'U'
   WHERE ActionListName = 'fskobject'
      AND DatabaseName = 'fsk'
      AND TableName = 'customer';