SAP HANA - Update
Overview
This Snap updates data in a database table. It executes an SQL UPDATE statement for each input document and writes the updated records to the output view.
- This is a Write-type Snap.
Works in Ultra Tasks
Supported Accounts
Prerequisites
None.
Limitations and known issues
None.
Snap views
| Type | Description | Examples of upstream and downstream Snaps |
|---|---|---|
| Input | This Snap has exactly one document input view. Document containing the values to update and the condition values for the WHERE clause. | |
| Output | This Snap has exactly one document output view. Document for each record updated, containing the number of rows affected. | |
| Learn more about Error handling.
Note: Database Write Snaps output all records of a batch (as configured in your
account settings) to the error view if the write fails during batch
processing. |
||
Examples
Update records in a table: Update records in a table based on ID.
Snap settings
Note:
Learn about the common controls in the Snap settings dialog.
| Field/Field set | Description |
|---|---|
| Label
|
Required. Specify a unique name for the Snap. Modify this
to be more appropriate, especially if more than one of the same Snaps is in the
pipeline.
Default value: SAP HANA - Update Example: Update employee records |
| Schema name
|
The database schema name. In case it is not defined, then the suggestion for the table name will retrieve all tables names of all schemas. The property is suggestible and will retrieve available database schemas during suggest values.
Default value: [None] Example: myschema |
| Table name
|
Required. The name of the table to update records in.
Default value: [None] Example: employees |
| Update condition
|
Required. The WHERE clause of the UPDATE statement. This supports document value substitution (such as $person.id will be substituted with the value found in the incoming document at that path).
Default value: [None] Example: id = $id |
| Number of retries
|
Specifies the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response.
Default value: 0 Example: 3 |
| Retry interval (seconds)
|
Specifies the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception.
Default value: 1 Example: 10 |
| Snap execution
|
Choose one of the three modes in which the Snap executes. Available options are:
Default value: Execute only |
Troubleshooting
None.