We have a requirement to get data from a UDB DB2 database and put it to a MySQL DB. Currently we use a stored procedure on DB2 side which populates the data into a global temporary table and fire a query on this "session" table to insert into MySQL database. When I am trying to create similar step in Kettle it's throwing an error saying session.xxx table is not available. Please let me know if we can access a session table populated by a previous step in kettle. I am using "Execute SQL script" for calling the procedure and then again to fire the select query.

Any pointers towards this would be really helpful.