In this example, we will update a record in a table.

This example updates a row of data in table TEST_EMPLOYEE which is defined as below:

CREATE TABLE "TECTONIC"."TEST_EMPLOYEE" (    
    "Title" VARCHAR2(4000 BYTE), "Employee_Name" VARCHAR2(4000 BYTE), "Employee_ID" VARCHAR2(4000 BYTE)
);

We need to change the Title column of the row that has "Cooper" as Employee_Name to "Senior Software Engineer". First we use a JSON Generator Snap to pass the new data:

Then we set up the table name and the update condition:

This is an example output of the pipeline: 

In this example, we will see how error handling works.

We are using the same pipeline as the one used in Example #1. The difference is this time we try to update the column "Titlee" which doesn't exist in TEST_EMPLOYEE table:

And this is the error message routed to the error view: 

In this example, we will use the well-known Northwind sample database.
 

Following is a selection from the "Customers" table:

Assume we wish to update the customer "Alfreds Futterkiste" with a new contact person and city.

Enter Customers in the Table name property and CustomerName='Alfreds Futterkiste' in the Update condition property.

Assume that the Update Snap receives a Map data in the input view as following:

{ "ContactName" : "Alfred Schmidt", "City" : "Hamburg" }

UPDATE Customers SET ContactName='Alfred Schmidt', City='Hamburg' WHERE CustomerName='Alfreds Futterkiste';

and submit the request to the database server.

 
The selection from the "Customers" table will now look like this:
 

Be careful when updating records. If we had omitted the Update condition property in the example above, the "Customers" table would have looked like this: