RE: Verifying Existence of a File on a Server

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

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.