RE: sql select from to servers

["Ellsberry, Steve" <steve.ellsberry@xxxxxxxxxxxx>]

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.