DSXchange

Hello,

I am extracting data from DB2 database using ODBC Enterprise stage.

The DB2 source has given a sql block to pull the data.

Please tell me if there is anyway / anystage where in i can give the DB2 connection and run this sql block.

i could call it using a stored procedure stage but the source is not willing to include this on their database ..

please advice,

- DS

Can't you use the Read Method = User-defined SQL to manually insert your SQL block on your ODBC stage? Why use the ODBC stage instead of the DB2/UDB Enterprise stage?