Search found 3 matches
- 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 ...
- 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...
- 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 ...