UPDATE statement
Function Usethis statement to modify data in the database.
Syntax1 UPDATEtable-list
SET column-name =expression,. . .
[VERIFY (column-name, .. . ) VALUES (expression, . .. )]
[WHERE search-condition ]
[ORDERBY expression[ASC |DESC ], . .. ]
Syntax2 UPDATEtable
PUBLICATIONpublication
{SUBSCRIBEBY expression|
OLDSUBSCRIBE BY expression
NEWSUBSCRIBE BY expression}
WHERE search-condition
expression:value|subquer y
Usage Syntax1 and Syntax 2 are applicable only to SQL Remote.
Syntax2 with no OLD and NEW SUBSCRIBE BY expressions must be
usedin a BEFORE trigger.
Syntax2 with OLD and NEW SUBSCRIBE BY expressions can be used
anywhere.
Permissions Musthave UPDATE permission for the columns being modified.
Sideeffects None.
Seealso “UPDATEstatement [SQL Remote]” [ASA SQL Reference, page 657]
“CREATETRIGGER statement” on page 359
378