Search found 3 matches

by davidpsalms77
Tue Mar 12, 2013 8:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL query extraction from oracle stage
Replies: 5
Views: 2410

I did not get you what trying to say. i know the problem came with array size defined. Defined array size may impact means,how it is impacting in the background.I need to show a proof that the problem came with data stage array size.Can you please explain me more clearly. We kept the array size ass ...
by davidpsalms77
Mon Mar 11, 2013 11:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL query extraction from oracle stage
Replies: 5
Views: 2410

select * from sample where id in (select id from sample where unit='522') and id in (select id from staging where unit='522') for all the records unit is same.Please help me to find out why i am not getting the correct results running through datastage,but getting correct results while running in da...
by davidpsalms77
Mon Mar 11, 2013 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL query extraction from oracle stage
Replies: 5
Views: 2410

SQL query extraction from oracle stage

Hi Team, I had encountred some problem in datastage oracle stage. I have query as below Select * from table A where id in (select id from table a) and id in (select id from table b). I used the above query to extract the data from oracle database,while runing the query using toad ,i am getting some ...