|
midrange.com
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
