OpenAccess SDK SQL Engine core methods for .NET : Methods for .NET reference : dam_getUpdateRowAsExp

dam_getUpdateRowAsExp

This method gets the update row that contains the values of columns and the corresponding update expressions. Using this method, the IP can directly send the UPDATE expression and SEARCH expression to the backend.

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

Related functions:

• Use damex_getFirstUpdateSet and damex_getNextUpdateSet to get the column and the UPDATE expression.

• Use damex_describeCol with the column handle to obtain the column details.

• Use damex_describeValExp and related methods to get the UPDATE expression for the column.

int64 dam_getUpdateRowAsExp(

int64 hstmt)

Table 184: Parameters for dam_getUpdateRowAsExp
Parameter	Type	Description
IN
hstmt	int64	The statement handle of the current statement.
RETURN
	int64	The handle to the update row. NULL is returned if an update row is not available. This handle can be passed to 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