286 PROC CV2ODBC Statement Chapter 17
SUBMIT;
REPLACE ALL | VIEW | FILE;
PROC CV2ODBC Statement
PROC CV2ODBC DBMS=AS400 | MSSQL;
Argument
DBMS= AS400 | MSSQL
specifies the DBMS from which the view is being converted. Conversion is supported
for the IBM AS/400 and Microsoft SQL Server. DBMS= is required.
FROM VIEW Statement
Specifies the view descriptor to convert
FROM <VIEW>=V6-view-descriptor-name <(PW=password)>;
Arguments
V6-view-descriptor-name
specifies the existing Version 6 PROC ACCESS view descriptor that is to be
converted. FROM VIEW= is required.
password
specifies a password, if one is associated with the view. If the view was created with
an optional SAS password, then the PW= statement is required. A SAS password is
used for accessing a SAS view file. If a Version 6 view was created with a SAS
password, then the password will always be associated with that view. Therefore, the
converted Version 9 view will require the SAS password for any procedures that it
uses.
TO VIEW Statement
Specifies the new view name
TO <VIEW>=V9-view-name;
Arguments
