CV2ODBC Procedure

UID Statement

Specifies an alternate userid.

UID | USER=user-id;

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 PASSWORD= values and uses them for the connection to the DBMS. If you do not know the UID 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 you have the proper permissions for that DBMS.