Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
_chamak
Premium Member
Posts: 29 Joined: Tue Aug 24, 2010 10:29 am
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
-Thanks
Chamak
kommven
Charter Member
Posts: 125 Joined: Mon Jul 12, 2004 12:37 pm
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
Premium Member
Posts: 29 Joined: Tue Aug 24, 2010 10:29 am
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?
-Thanks
Chamak
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Oct 06, 2011 10:23 am
Let us know if
this helps.
-craig
"You can never have too many knives" -- Logan Nine Fingers
kommven
Charter Member
Posts: 125 Joined: Mon Jul 12, 2004 12:37 pm
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
Premium Member
Posts: 29 Joined: Tue Aug 24, 2010 10:29 am
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,
-Thanks
Chamak