CV2ODBC Procedure

DSN Statement

Specifies the data source name.

DSN=data-source-name;

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 IBM AS/400 Specifics or MS SQL Server Specifics.