This illustration shows the following syntax on a horizontal line:
EXEC SQL
AT db_name (on a loop)
FOR :host_integer (on a loop)
:host_variable (on a loop)
UPDATE
TABLE (on a loop)
schema (on a loop)
view (on a loop)
@dblink (on a loop)
alias (on a loop)
SET ( column ) - ( subquery_1 )
column = expr (on a loop)
( subquery_2 ) (on a loop)
WHERE condition (on a loop)
CURRENT OF cursor (on a loop)