%ForUpdateOf meta-SQL element

Syntax

%ForUpdateOf(column_list)

Description

The %ForUpdateOf meta-SQL function replaces the For Update Of syntax in the Select for Update SQL statements.

Parameters

Parameter	Description
column_list	Specify the column or columns of a database.

Example

SELECT ENRL_CAP, WAIT_CAP, ENRL_TOT, WAIT_TOT, ENRL_STAT, NEXT_STDNT_POSITIN, COMBINED_SECTION 
FROM PS_CLASS_TBL WHERE STRM = :1 AND CLASS_NBR = :1 %ForUpdateOf(ENRL_TOT, WAIT_TOT, ENRL_STAT)