Re: sql select from to servers

[rob@xxxxxxxxx]

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.