Previous Page | Next Page

The CV2VIEW Procedure

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


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, then the procedure moves to the next view. The PROC SQL statements that are generated by PROC CV2VIEW 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;

Previous Page | Next Page | Top of Page