CV2VIEW Procedure

Example 3: Converting a Library of View Descriptors for All Supported DBMSs

Features:

PROC CV2VIEW option: DBMS=ALL

Statements:
PROC CV2VIEW
FROM_LIBREF=
TO_LIBREF=
In this example PROC CV2VIEW converts all view descriptors that are in the input library and that access data in any supported DBMS. If an error occurs during the conversion of a view descriptor, the procedure then moves to the next view. The PROC SQL statements that PROC CV2VIEW generates are automatically submitted but are not saved to an external file because the SAVEAS= statement is not used.
libname input '/username/descriptors/';
libname output '/username/sqlviews/';

proc cv2view dbms=all;
from_libref = input;
to_libref = output;
run;