Unlock the Potential of Heterogeneous Data with Passthru ESQL

PASSTHRU Statement: evaluates an expression and runs the resulting character string as a database statement. Ex:- PASSTHRU 'CREATE TABLE Shop. I am working on IBM Websphere Message Broker v6.0 and writing a message flow in ESQL. I am using passthru to fire a select query on database. Avoid the use of the PASSTHRU statement with a CALL statement to invoke a stored procedure. As an alternative, you can use the CREATE PROCEDURE ... According to the WMB information center, PASSTHRU function(or statement) can be used along with Database keyword for this purpose. The main use of the PASSTHRU statement is to issue administrative commands to databases (for example, to create a table). To become master in websphere message broker, you have to be a master in ESQL ... PASSTHRU; Stored Procedures; Manipulating repeating fields ... v For descriptions of ESQL user tasks, see “Writing ESQL” on page 25. v For ... PASSTHRU statement” on page 249 can be used to invoke administrative. IBM Integration Bus v10 Tutorials ESQL Examples ESQL IF ELSE Condition ESQL DO WHILE Loop. ... passthru statements always expect to return results to an array. These statements are not interpreted by ESQL and executed against a datasource, ESQL doesn ... To run a query on a database server, use a pass-through query which is a Transact SQL (TSQL) statement that connects to SQL Server by using an ODBC connection ...