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.