|
View previous topic :: View next topic
|
| Author |
Message |
ajaypmenon
New User
Joined: 30 Mar 2007
Posts: 21
Location: North Carolina
|
|
|
|
Hi,
I need to use DB2 High Performance unload for joined tables. I would like to know whether this can be done. We have not tried it since we are in the design phase. We need to come up with different approaches.
For e.g. Can i unload results by giving the SQL
select a.col1, b.col1 from table1 a, table2 b where a.col2 = b.col2
Any help would be highly appreciated.
Thanks in advance,
Aj |
|
| Back to top |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
| Quote: |
Can i unload results by giving the SQL
select a.col1, b.col1 from table1 a, table2 b where a.col2 = b.col2 |
Of course you can do. Not just join, you can use all other variety available on DB2.
| Quote: |
| We have not tried it since we are in the design phase |
It doesn't take much time to try this one out. Suggest you go ahead and try your requirement. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
What does "High Performance" referes to here? Please assist.
| Quote: |
| DB2 High Performance |
|
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Thnaks Gnanas N.. 
Any how google is not working for me today in office.. 
Have a good one,
-Ad |
|
| Back to top |
|
|
ajaypmenon
New User
Joined: 30 Mar 2007
Posts: 21
Location: North Carolina
|
|
|
|
Hi,
Thank you all for the help. Will definitely try this one out. I really appreciate your help.
Thanks,
Ajay |
|
| Back to top |
|
|
|
|
