DB2 Connector

_chamak · Post by **_chamak** » Thu Oct 06, 2011 8:50 am

Hi,

Like Oracle, can we read a select stetement from from a file in DB2.
I have a select statement in a file and I need to read that file and develop a ETL job.

Can someone please advice?

Thanks

kommven · Post by **kommven** » Thu Oct 06, 2011 9:14 am

That was always attributed as a "must have" feature.
I surely know that its there in DB2 Connector Stage and EE Stage and Plug-in it should be there. I'm unable to check it as Plug-in is out in 8.5

_chamak · Post by **_chamak** » Thu Oct 06, 2011 9:51 am

I am using 8.1 but still i dont see any.

Can you tell how to use it?

chulett · Post by **chulett** » Thu Oct 06, 2011 10:23 am

Let us know if this helps.

kommven · Post by **kommven** » Thu Oct 06, 2011 10:23 am

Again I don't have 8.1,

In 8.5 Connector Stage.

Select "Generate SQL" to "No"
Select "Read Select Statement from file" to "Yes"
click select statement box and "..." browse to your SQL file.

Note doing it in above order worked for me.

_chamak · Post by **_chamak** » Thu Oct 06, 2011 11:09 am

chulett wrote:Let us know if this helps.

Simply awesome. Thanks a lot Chullet. It worked for me.

Thanks,