M2M AD301 Guia do Utilizador descarregar pdf (Página 182)

Operator reference

170 Data Integration with Sybase Avaki Studio

• The data types of the result set columns (by ordinal position) and the parameters of

the database operation (by ordinal position) must match.

• The database operation must be defined with the “Supports batch operations”

option enabled.

In batch mode, the output of the Update operator can be either the input result set

(passed through with no changes) or, like in mapped parameter mode, a single-row

result set consisting of the UPDATE_COUNT column.

Connections

The Update operator takes zero or one input result sets, which can be the output of an

Input Source or of any other operator. It produces exactly one output result set. The

schema of the output result set is either the same as the input or a single column named

UPDATE_COUNT, of type INTEGER. See “Specifying the output” on page 173 for

details.

Performance notes

An Update operator produces no output until the update operation is done, regardless

of the mode.

Required Connection

1 2 ... 177 178 179 180 181 182 183 184 185 186 187 ... 229 230

Sem comentários

M2M AD301 Guia do Utilizador Página 182