SQL is the industry standard language for accessing and updating database data and ESQL is a language derived from SQL Version 3, particularly suited to. Use ESQL statements and functions to read from, write to, and modify databases from your message flows. Customize processing implemented by the Compute, Database, DatabaseInput, and Filter nodes in your message flows by coding ESQL.
|Published (Last):||8 August 2006|
|PDF File Size:||14.72 Mb|
|ePub File Size:||1.41 Mb|
|Price:||Free* [*Free Regsitration Required]|
Top 3 hidden treasures (in ESQL) – IBM Integration
You can use ESQL statements to manipulate message trees, update databases, or interact with nodes. The following table summarizes the ESQL statements and what ibmm do.
Statement type Description Basic statements: IF statement Processes a set of statements based on the result of evaluating condition expressions. LOOP statement Processes a sequence of statements repeatedly and unconditionally. If the expression evaluates to TRUE, executes the statements again.
SET statement Evaluates a source expression, and assigns the result to the target entity. Message tree manipulation statements: FOR statement Iterates through a list for example, a message array.
MOVE statement Changes the field pointed to by a target reference variable. LOG statement Writes a record to the event or user trace log. This is used by an error handler, when it cannot handle an exception, to give an error handler in higher scope the opportunity of handling the exception. Uses rules defined in WHEN clauses to select a block of statements to execute.
Creates a module a named container associated with a node. Declares one or more variables that can be used to store temporary values.
Processes a set of statements based on the result of evaluating condition expressions. Processes a sequence of statements repeatedly and unconditionally.
Processes a sequence of statements, then evaluates a condition expression. Stops processing the current function or procedure and passes control back to the caller. Evaluates a source expression, and assigns the result to the target entity. Evaluates a condition expression, and if it is TRUE executes a sequence of statements.
Message tree manipulation statements:. Attaches a portion of a message tree into a new position in the message hierarchy. Detaches and destroys a portion of a message tree, allowing its memory to be reused.
Detaches a portion of a message tree without deleting it.
Iterates through a list for example, a message array. Changes the field pointed to by a target reference variable. Deletes rows from a table in an external database based on a search condition.
Takes a character value and passes it as an SQL statement to an external database. Updates the values of specified rows and columns in a table in an external database. Propagates a message to the downstream nodes within the message flow. This statement is optional and is used in an ESQL file to explicitly identify the schema that contains the file.
Takes a character value, interprets it as an SQL statement, and executes it. Writes a record to the event or user trace log. Re-throws the current exception if any.