DSXchange

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

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

I am using 8.1 but still i dont see any.

Can you tell how to use it?

Let us know if this helps.

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.

chulett wrote:Let us know if this helps.

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

Thanks,