Interaction with databases using ESQL

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

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

You can access user databases from Compute, Database, and Filter nodes. The database access capabilities of all these nodes is identical.

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 accesses a database, to provide maximum flexibility.

Start of changeFor information about configuring the broker and the database to support access from message flows, see Accessing databases from ESQL.End of change

Related concepts
Message flows overview
ESQL overview
Related tasks
Configuring globally coordinated message flows
Accessing databases from message flows
Managing ESQL files
Related reference
mqsichangebroker command
mqsicreatebroker command
mqsisetdbparms command
Compute node
Database node
Filter node
ESQL reference
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:22:24

ak05800_