Updating Database Records

Automate database record updates with the Database Book.

Updating a Singular Database Record

To update a singular database record, you need to first identify the record to be updated. To learn more about this, see Retrieving Database Records and Storing Retrieved Records.

Example

get a database's person whose FirstName is "Jane"
use the above as the records
use the first record as the person
set the person's DOB to '1990-01-01'

In this example:

• Line 1: Retrieves a database record.

• Line 2: Stores the retrieved records as the records.

• Line 3: Stores only the first record from the records as the person.

• Line 4: Updates the DOB of the person.

Updating a Table in a Database

This procedure updates a table in the database with data from a table in Kognitos. The columns of the input table must match the columns of the database table.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the table	Table

Syntax

In this syntax, replace name with the name of the database table to update.

update the table in database with
    the table name is "<name>"

Example

create a json
use the above as the first json
set the first json's name to "John"

create a json
use the above as the second json
set the second json's name to "Jane"

convert the jsons to a table
use the above as the table
update the table in database with
    the table name is "PEOPLE_TABLE"