Update Operator

Use the Update operator to invoke a database operation that performs SQL insert or update operations against a connected database.

The database operation must have the “Modifies Database” option set in order for it to work with an Update operation.

There are two ways to use an Update operator:

• Mapped Parameter Mode

  You can use an Update operator to perform single-row updates based on parameter values. In this mode, it behaves analogously to an Input Source, in that it has no input result set—it just takes the parameter values/expressions that you specify and passes them on to the database operation, returning a result set consisting of one row and one column (UPDATE_COUNT).

• Batch Mode

  Alternatively, you can route any flow whose result set matches the parameters of the database operation as an input to the Update operator. In order to use this mode:

  
  

  • You must have connected an input to the Update operator.

  • The input to the Update operator must have the same number of columns as the database operation has parameters.

  • 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, as in mapped parameter mode, a single-row result set consisting of the UPDATE_COUNT column.

• Setting Update Properties
  The properties that you edit vary depending on whether you are using your Update operator in mapped parameter mode or in batch mode.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.