RE: Ddm files

Where this gets awkward is when you need to join a "remote" table with a
"local" table. DB2 does not allow for connections to multiple hosts to be open
concurrently...... As far as I know, the only solution is to

CONNECT TO REMOTESYS
create table qtemp/mytable as (
select * from rmtlib/rmttbl ) with data

Then

CONNECT RESET
select * from loclib/loctbl a inner join
qtemp/mytable b on (a.k1=b.k1)

Not very efficient, but at least it works....

Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of vhamberg@xxxxxxxxxxx
Sent: Wednesday, May 09, 2007 3:35 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Ddm files


True - but they have to be sure set up an RDB directory entry for the other
system - that is easy. And this technique does NOT use DDM, just so no one is
confused. It does use a SET CONNECTION kind of thing in embedded SQL - easy.
You can even try things out in interactive SQL.

HTH
Vern

-------------- Original message --------------
From: "Ruthirapathi, Arulanandham" <Arulanandham.Ruthirapathi@xxxxxxxxxxxxxxx>

You could use sql connecting to different as/400 system and do
processing on that file. You would need to create SQL Package for that.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Rubino, Jim
Sent: Tuesday, May 08, 2007 6:41 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Ddm files

You can do DSPPFM on the DDM file to see what is in there or you can use
DBU to view what is in the DDM file.

Jim


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of VanEaton, George
Sent: Tuesday, May 08, 2007 12:44
To: rpg400-l@xxxxxxxxxxxx
Subject: Ddm files

Does anyone know how to create a ddm file on another AS400 that will let
you access the data using SQL or query? We have 2 Iseries and mutiple
ddm files on both iseries. However, you can not query the data in any
of the ddm files.

Thanks



George Van Eaton
Systems Analyst
Purolator Filters NA LLC
george.vaneaton@xxxxxxxxxxx
Phone 615.377.1508
Fax 615.377.1520



**********************************************************************
This email and any files transmitted with it are confidential and are
the property of Purolator Filters NA LLC and are intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system
manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**********************************************************************
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
E-mail messages may contain viruses, worms, or other malicious code. By
reading
the message and opening any attachments, the recipient accepts full
responsibility for taking protective action against such code. Henry Schein
is
not liable for any loss or damage arising from this message.

The information in this email is confidential and may be legally privileged.
It
is intended solely for the addressee(s). Access to this e-mail by anyone else
is
unauthorized.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.