Re: sql select from to servers

Don't know.  Here's the part that will put the itching powder in your 
underwear.  Use the sql statement commonly used to deal with multiple 
member files.
CREATE ALIAS ROB/MORGAN2 FOR ROUTINES/IFSLIST (D200504221)
DSPFD ROB/MORGAN
File Description Header  
  File  . . . . . . . . . . . . . . . . . . . : FILE       MORGAN2  
  Library . . . . . . . . . . . . . . . . . . :            ROB  
  Type of file  . . . . . . . . . . . . . . . :            Device  
  Device type . . . . . . . . . . . . . . . . :            DDM  
  Auxiliary storage pool ID . . . . . . . . . :            00001  
DDM File Attributes  
  File level identifier . . . . . . . . . . . :            1050422103530  
  Creation date . . . . . . . . . . . . . . . :            04/22/05  
  Remote file . . . . . . . . . . . . . . . . : RMTFILE 'ROUTINES/IFSLIST
  
  Remote location                               RMTLOCNAME  
   Name or address . . . . . . . . . . . . . :            '*LOCAL'
   Type  . . . . . . . . . . . . . . . . . . :            *SNA 

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





"Paul Morgan" <pmorgan@xxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/22/2005 10:20 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
Re: sql select from to servers






Doh!

Why couldn't it?  DDM files aren't in the SQL system tables?

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

Rob wrote

> SQL doesn't work on ddm files.
>
> Rob Berendt



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