The CV2ODBC Procedure Example 1: Converting an AS/400 View Descriptor 289
enables you to automatically submit the PROC SQL statements that are generated
by PROC CV2ODBC. If you specify a value for SAVE=, then the statements are not
automatically submitted for processing. The SUBMIT statement is not necessary if
you have not specified a value for SAVE=.
REPLACE Statement
Enables replacement of existing views and files
REPLACE ALL | VIEW | FILE;
Arguments
ALL
enables you to overwrite existing views and files of the same name. Replaces both an
existing TOVIEW= view and a SAVE= file if they already exist.
FILE
replaces the SAVE= file if it already exists. If the file already exists, and if
REPLACE FILE or REPLACE ALL are not specified, the generated PROC SQL code
will be appended to the file.
VIEW
replaces the TOVIEW= view if it already exists.
CV2ODBC Procedure Examples
Example 1: Converting an AS/400 View Descriptor
In this example, PROC CV2ODBC converts the Version 6 As4Acc.Invoice view
descriptor to an ODBC view, As4Lib.V9_Invoice. The PROC SQL statements that are
generated by PROC CV2ODBC are both automatically submitted and saved to an
external file named As4_Invoice.sas.
libname as4acc ’d:\lib\as4\acc’;
libname as4lib ’d:\lib\as4\lib’;
proc cv2odbc dbms=as400;
from view=as4acc.invoice;
to view=as4lib.V9_invoice;
user=’testuser’;
password=’testpass’;
dsn=’IBM AS/400 Database’;
save =’as4_invoice.sas’;
