17.00 - Example: Updating ActionsTbl Row - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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