SQL Remote User's Guide
  Command Reference for Adaptive Server Anywhere

UPDATE statement

Function 

Use this statement to modify data in the database.

Syntax 1 

UPDATE table-list
SET column-name = expression, ...
[ VERIFY ( column-name, ... ) VALUES ( expression, ... ) ]
[ WHERE search-condition ]
[ ORDER BY expression [ ASC | DESC ], ... ]

Syntax 2 

UPDATE table
PUBLICATION publication
{ SUBSCRIBE BY expression |
   OLD SUBSCRIBE BY expression
   NEW SUBSCRIBE BY expression }
WHERE search-condition

expression: value | subquery

Usage 

Syntax 1 and Syntax 2 are applicable only to SQL Remote.

Syntax 2 with no OLD and NEW SUBSCRIBE BY expressions must be used in a BEFORE trigger.

Syntax 2 with OLD and NEW SUBSCRIBE BY expressions can be used anywhere.

Permissions 

Must have UPDATE permission for the columns being modified.

Side effects 

None.

See also 

UPDATE statement [SQL Remote]

CREATE TRIGGER statement