Progress
SQL-89
Guide and Reference


Positioned UPDATE

The positioned form of the UPDATE statement is used with an open cursor. Once you have used the cursor statement FETCH to retrieve a row, you can individually update one or more columns in that row.

The positioned UPDATE statement has the following general syntax.

SYNTAX
UPDATE table-name 
  SET column-name = { NULL | expression }
      [ , column-name = { NULL | expression } ] ...
  WHERE CURRENT OF cursor-name 

The table in the positioned UPDATE statement is the same table associated with the cursor in the DECLARE CURSOR statement. The SET clause sets the specified columns to their new values, as derived from the expressions. The WHERE CURRENT OF clause uses the cursor-name to identify the cursor whose current row is to be updated.

You cannot update a cursor if it is defined for a SELECT statement that contains any of the following clauses or expressions:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095