A SERVICE OF

logo

285
CHAPTER
17
The CV2ODBC Procedure
Overview of the CV2ODBC Procedure
285
Procedure Syntax
285
PROC CV2ODBC Statement
286
FROM VIEW Statement
286
TO VIEW Statement
286
DSN Statement 287
UID Statement
287
PASSWORD Statement
288
SAVE Statement
288
SUBMIT Statement
288
REPLACE Statement 289
CV2ODBC Procedure Examples
289
Example 1: Converting an AS/400 View Descriptor 289
Example 2: Converting an Microsoft SQL Server View Descriptor 290
Overview of the CV2ODBC Procedure
The CV2ODBC procedure is used to convert Version 6 view descriptors for the
AS/400 or Microsoft SQL Server to Version 9 ODBC SQL views for Windows. This
section contains the syntax for the CV2ODBC procedure and examples of its use.
Note: The conversion of PROC SQL Pass-Through views is automatic and does not
require you to use the CV2ODBC procedure. See for more information.
Procedure Syntax
The syntax for the CV2ODBC procedure is as follows:
PROC CV2ODBC DBMS=AS400 | MSSQL;
FROM <VIEW>=V6-view-descriptor <(PW=password)>;
TO <VIEW>=V9-view-name;
DSN=data-source-name;
UID | USER=user-id;
PWD | PASSWORD | PW=password;
SAVE <AS=>filename;