278 Procedure Syntax Chapter 16
Procedure Syntax
The syntax for the CV2VIEW procedure is as follows:
PROC CV2VIEW DBMS= dbms-name | ALL ;
FROM_VIEW= input-view;
FROM_LIBREF= input-libary;
TO_VIEW= output-view;
TO_LIBREF= output-library;
SAVEAS= filename;
SUBMIT;
REPLACE <ALL>|VIEW | FILE;
PROC CV2VIEW Statement
PROC CV2VIEW DBMS= dbms-name | ALL;
Argument
DBMS= dbms-name | ALL
identifies which DBMS is accessed by the view descriptor(s) that you want to convert.
This argument is required.
To convert all of the view descriptors that are in the specified library and that
access any supported DBMS, specify DBMS=ALL. To identify a specific DBMS, specify
its name in dbms-name. Valid values for dbms-name are
DB2, Oracle, and
SYBASE.
FROM_VIEW= Statement
Specifies the name of the view descriptor that you want to convert
Requirement: You must specify either the FROM_VIEW statement or the
FROM_LIBREF statement.
Requirement: The FROM_VIEW and TO_VIEW statements are always used together.
Restriction:
If you specify DBMS=ALL, then you cannot use the FROM_VIEW statement.
FROM_VIEW=libref.view-name;
Arguments
