288 PASSWORD Statement Chapter 17
PASSWORD Statement
Specifies the ODBC password
PWD | PASSWORD | PW= password;
Argument
password
specifies the DBMS password that is associated with your DBMS user ID. 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.
SAVE Statement
Saves the PROC SQL statements that are generated by PROC CV2ODBC to a file
SAVE <AS=>filename;
Argument
filename
enables you to save the PROC SQL statements that are automatically generated by
PROC CV2ODBC to an external file. You can modify this file as needed and submit it
on another platform that supports ODBC. If you specify a value for SAVE=, then the
PROC SQL statements are not automatically submitted.
SUBMIT Statement
Enables automatic submission of the PROC SQL statements that are generated by PROC CV2ODBC
SUBMIT<statements>;
Argument
statements
