RE: sql select from to servers

I think the problem was how do you CONNECT to two systems at once?  For 
example, a left outer join between a local file and remote file.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Ellsberry, Steve" <steve.ellsberry@xxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/22/2005 11:12 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: sql select from to servers






You are correct. SQL and DDM do not get along. 

Just curious...
Why not use SQL to "Connect" to the remote database? Always works for me. 

-----Original Message-----
From: Raul A. Jager W. [mailto:raul@xxxxxxxxxx] 
Sent: Friday, April 22, 2005 12:02 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: sql select from to servers

I tryed...  seems that SQL does not like DDM Files.
___________________________________________________________________________
                        Información Adicional de Mensaje

 ID de mensaje  . . . . :   SQL7011       Gravedad . . . . . . . :   30
 Tipo de mensaje  . . . :   Diagnóstico

 Mensaje . . . . :   ADDRES_REM en B no es una tabla, vista o archivo 
físico.
 Causa . . . . . :   La sentencia SQL *N no puede realizarse en un 
archivo que
   no sea una tabla, vista, archivo lógico de formato único o archivo
físico.
 Recuperación  . :   Efectúe una de las acciones siguientes:
     -- Utilice un mandato de lenguaje de control (CL) para realizar la
   función.
     -- Seleccione la tabla, vista, archivo lógico o archivo físico
correctos.
____________________________________________________________________________
__
Paul Morgan wrote:

>Raul,
>
>If you have communication between the two systems you could create a 
>DDM file on one system that pointed to the file on the other system. 
>Put the DDM file into a different library or just name the DDM file 
>with a different name than the file you're comparing against.  This DDM 
>file could then be used in a SQL statement along with the physical file 
>you're comparing against.  Not very great for performance but it'll get 
the
job done.
>
>Instead of using the DDM file directly you could use the DDM file as a 
>method to copy over the file for comparison (instead of using FTP, 
>save/restore or SNADS).  Create the DDM file.  Use CPYF CRTFILE(*YES)
>FROMRCD(1) to copy over the file.  Run your SQL comparison against the 
>copied file.
>
>Paul
>
> 
>



--
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.