SQL Statements › UPDATE › Positioned UPDATE

Positioned UPDATE

Following is the syntax diagram for the positioned UPDATE statement that you use with a cursor:

►►─ UPDATE ─┬─ table-name ─┬─┬────────────────────┬─ SET ─────────────────────►
            └─ view-name ──┘ └─ correlation-name ─┘

   ┌─ , ────────────────────────────┐
 ►─▼─ column-name ─┬─ expression ─┬─┴─ WHERE CURRENT OFcursor-name ───────────►◄
                   └─ NULL ───────┘