RE: Verifying Existence of a File on a Server

Note sure when support for CREATE ... AS was added, but v5r3 and higher
supports it for sure.

create table InvBinMst (        
  plantID,                           
  stockRoom,                         
  binLocation for binLoc,            
  binDescription for binDesc,        
  lastModifiedByUser for lastModUsr, 
  entryTimestamp for entryTs         
)                                    
  as ( select                        
         plantID,                    
         stockRoom,                  
         binLocation,                
         description,                
         lastModifiedByUser,         
         entryTimestamp              
       from FieldReferenceTable           
) with no data                       

HTH,


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx 
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Fisher, Don
Sent: Thursday, September 07, 2006 10:47 AM
To: Midrange Systems Technical Discussion
Subject: RE: Verifying Existence of a File on a Server

Datalink fields look very interesting.  It appears, however, 
they can only be defined via s.q.l.  That means I either 
redefine the file that way or create a new file with just the 
key fields and the datalink field.  Either answer has a 
couple of problems.  The first is that some folks here might 
balk at a file defined without d.d.s. and the second is the 
file would have to be defined without using reference fields. 
 At least I don't know of a way to use reference fields in s.q.l.  

Donald R. Fisher, III
Project Manager
RoomStore, Inc.
(804) 784-7600 ext. 2124
dfisher@xxxxxxxxxxxxx

<clip>
A fun exercise with DataLink fields perhaps?
<clip>

-- 
This is the Midrange Systems Technical Discussion 
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.