Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Clauses > WHERE Clause Syntax and Description > FOR UPDATE OF Clause

FOR UPDATE OF Clause

Restriction: This topic applies to Windows environments only.

The FOR UPDATE OF clause identifies the columns that can be updated in a later positioned UPDATE statement. It restricts the table columns that can be updated to those specified in the column-name list. These column names must be defined for the table or view appearing in the first FROM clause of the fullselect, and must not be qualified. FOR UPDATE OF cannot be used if the result table is read-only, nor can it be used in a statement containing a FOR FETCH ONLY clause.

Syntax

The FOR UPDATE OF clause format appears below: 

FOR UPDATE OF column-name[,...]

where:

column-name An unqualified column name that must be a column of the table or view identified in the first FROM clause of the fullselect.
Parent topic: WHERE Clause Syntax and Description
Previous Topic Next topic Print topic