RE: Verifying Existence of a File on a Server

I completely missed that when I read the manual.  That's very interesting.  
Perhaps I'll play with that some.

Thanks.

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

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