OpenAccess SDK SQL Engine Core Functions API : Function Reference : dam_getUpdateRowAsExp

dam_getUpdateRowAsExp

This function gets the update row that contains the values of columns and the corresponding update expressions. This function can be used when the IP implementer wants the IP to directly send the update expression and search expression to the backend.

In row-based processing, dam_getUpdateRow is used when the IP first searches for target records and then updates each selected row.

Use the advanced functions damex_getFirstUpdateSet and damex_getNextUpdateSet to get the column and update expression.

Use the SQL Engine Parse Tree functions, damex_describeCaseValExp with the column handle to retrieve the column details, and damex_describeValExp to get the update expression for the column.

DAM_HROW dam_getUpdateRowAsExp(
DAM_HSTMT hstmt)

Table 159. Parameters for dam_getUpdateRowAsExp
Parameter	Type	Description
IN
hstmt	DAM_HSTMT	The statement handle of the current statement.
RETURN
	DAM_HROW	The handle to the update row. NULL is returned if an update row is not available. This handle can be passed to the advanced functions damex_getFirstUpdateSet and damex_getNextUpdateSet. Do not call dam_freeRow on this handle to free this row. It is automatically freed by the OpenAccess SDK SQL engine.

dam_getUpdateRowAsExp

See also