The REPLACE FILE statement
causes an existing file named SQL.SAS to be overwritten. Without this
statement, the text would be appended to SQL.SAS if the user has the
appropriate privileges.
The LABEL value of
EMPLINFO
is
the name of the underlying database table that is referenced by the
view descriptor.
If the underlying DBMS
is Oracle or DB2, the CV2VIEW procedure adds the PRESERVE_TAB_NAMES=
option to the embedded LIBNAME statement. You can then use CV2VIEW
to access those tables with mixed-case or embedded-blank table names.
Note: This SQL syntax fails if
you try to submit it because the PW field of the LIBNAME statement
is replaced with a comment in order to protect the password. The ALTER,
READ, and WRITE protection is commented out for the same reason. You
can add the passwords to the code and then submit the SQL to re-create
the view.