Re: Creating a view

[CRPence <crp@xxxxxxxxxxxxxxxxxxxx>]

  An override will not influence the creation-time reference in SQL 
DDL.  Overrides are for run-time and open.  Albeit some functions honor 
overrides [by request] to assist with open; e.g. asking for file 
definitions against which an override would redirect an open for that 
file name, enables extracting attributes about a file that is about to 
be opened.  The SQL CREATE will look for [resolve to] the named file 
object and first member without regard to any overrides.  For the 
run-time opens, although the files named in a DML statement can be 
redirected to another file, the file named in an existing VIEW can not 
be redirected during run-time; the already resolved file.mbr is always 
file.*first.  Neither ALIAS nor DDS LF can be referenced in a VIEW.