Interaction with databases using ESQL

Use ESQL statements and functions to read from, write to, and modify databases from your message flows.

About this task

ESQL has a number of statements and functions for accessing databases:

The CALL statement invokes a stored procedure.
The DELETE FROM statement removes rows from a database table.
The INSERT statement adds a row to a database table.
The PASSTHRU function can be used to make complex selections.
The PASSTHRU statement can be used to invoke administrative operations (for example, creating a table).
The SELECT function retrieves data from a table.
The UPDATE statement changes one or more values stored in zero or more rows.

You can access databases from Compute, Database, DatabaseInput, and Filter nodes. The same ESQL functions and procedures are supported in all these nodes.

You can use the data in the databases to update or create messages, or use the data in the message to update or create data in the databases.

Select Throw exception on database error and Treat warnings as errors, and set Transaction to Automatic on each node that access a database, to provide maximum flexibility.

For information about configuring the integration node and the database to support access from message flows, see Accessing databases from ESQL.