RE: Query joining tables on 2 separate LPAR

[michael@xxxxxxxxxxxxxxxxxx]

That's correct. The fact that they're on LPARs doesn't matter - it's the
same as if they were two physical systems across the country from each
other. Of course, if one of the tables is static, you could transfer
the table to the partition with the dynamic data - then it would be
local and could be processed.

> -------- Original Message --------
> Subject: Re: Query joining tables on 2 separate LPAR
> From: "Jim McLean" <Jim.McLean@xxxxxxxxxx>
> Date: Tue, June 14, 2005 9:41 am
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> So, this isn't possible then?
> 
> Jim McLean
> 
> 
> 
>                                                                            
>              rob@xxxxxxxxx                                                 
>              Sent by:                                                      
>              midrange-l-bounce                                          To 
>              s@xxxxxxxxxxxx            Midrange Systems Technical          
>                                        Discussion                          
>                                        <midrange-l@xxxxxxxxxxxx>           
>              14/06/2005 09:31                                           cc 
>              AM                                                            
>                                                                    Subject 
>                                        Re: Query joining tables on 2       
>              Please respond to         separate LPAR                       
>              Midrange Systems                                              
>                  Technical                                                 
>                 Discussion                                                 
>              <midrange-l@midra                                             
>                  nge.com>                                                  
>                                                                            
>                                                                            
> 
> 
> 
> 
> Suggest you submit a DCR or Design Change Request.  Lot of people
> requesting this, and, also requesting the ability for imbedded SQL, etc to
> be able to talk to MS SQL Server.
> https://www-912.ibm.com/r_dir/ReqDesChange.nsf/Request_for_Design_Change?OpenForm
> 
> 
> 
> "And the only reason I'm singing you this song now is cause you may know
> somebody in a similar situation, or you may be in a similar situation, and
> if your in a situation like that there's only one thing you can do and
> that's walk into the shrink wherever you are ,just walk in say "Shrink,
> You can get anything you want, at Alice's restaurant.".  And walk out. You
> know, if one person, just one person does it they may think he's really
> sick and they won't take him.  And if two people, two people do it, in
> harmony, they may think they're both faggots and they won't take either of
> them. And three people do it, three, can you imagine, three people walking
> in singin a bar of Alice's Restaurant and walking out. They may think it's
> an organization.  And can you, can you imagine fifty people a day,I said
> fifty people a day walking in singin a bar of Alice's Restaurant and
> walking out.  And friends they may thinks it's a movement."
> "Alice's Restaurant" by Arlo Guthrie.
> http://www.arlo.net/lyrics/alices.shtml
> 
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> "Jim McLean" <Jim.McLean@xxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 06/13/2005 01:02 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> midrange-l@xxxxxxxxxxxx
> cc
> 
> Subject
> Query joining tables on 2 separate LPAR
> 
> 
> 
> 
> 
> 
> Hey Everybody,
> 
> I've been reading though the iSeries infocenter and I'm a little confused.
> 
> Here's the situation... I have 2 tables.  One on system A and one on
> system
> B.  I want to run a query of this form; 'select a.*, b.* from a inner join
> b on a.id = b.id'
> 
> 1. Is this possible?
> 2.  How?  Do I need to setup DRDA connections, etc?
> 
> 
> 
> Jim McLean
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.