The CV2ODBC Procedure UID Statement 287
V9-view-name
specifies the new Version 9 view name that you want to create. TO VIEW= is
required. If PW= is specified in the FROM= statement, for security reasons, it is
automatically applied to this view. You will also have to specify PW= when you open
this new created view. If you do not specify PW=, then you will be prompted for it
when the view is processed within a DATA step or another procedure.
DSN Statement
Specifies the data source name
DSN=data-source-name;
Argument
data-source-name
specifies the data source name that you created for the DBMS in the ODBC
Administrator. DSN= is optional. If it is omitted, then the environment variable or
default value is used. For the AS/400, the environment variable is AS400DSN, and
the default value is
AS400. For MS SQL Server, the environment variable is
MSSQLDSN, and there is no default value. For more information about these
environment variables, see or .
UID Statement
Specifies an alternate user ID
UID | USER=user-id;
Argument
user-id
enables you to connect to the database with a user ID that is different from the
default DBMS login connection ID. UID= is optional. When you use PROC
CV2ODBC, you should use the same UID= and PW= values that were used to create
the Version 6 view. PROC CV2ODBC validates the UID= and PW= values and uses
them for the connection to the DBMS. If you do not know the user ID or password
that is specified in the Version 6 view, then you can specify any valid user ID and
password for the connection to the DBMS, provided that you have the proper
permissions for that DBMS.
