Linux ODBC/MX Client Driver for SQL/MX Release 3.2 (H06.25+, J06.14+)

Catalog = DS1CAT
Schema = DS1SCH
Server = TCP:xxx.xxx.xxx.xxx:xxxx
SQLIntervalBehaviour = SYSTEM_DEFAULT
[DS2]
Description = Sample Data Source 2
Catalog = DS2CAT
Schema = DS2SCH
SQLIntervalBehaviour = SYSTEM_DEFAULT
[DataSourceName]
Driver = NonStop ODBC/MX
Managing data sources
To add a new DSN entry in the MXODSN file, include the DSN and its description. If the values of
the attributes are not specified in the MXODSN file, the driver uses default values when creating a
connection.
To modify or delete a DSN entry, complete the following steps:
1. Modify the MXODSN file attributes or remove the DSN entry, and then save the file.
2. Restart the application to reflect the changes.
NOTE: The MXODSN file changes come into effect only when you restart the application.
Tracing
You can enable or disable tracing by modifying the TraceStart attribute in MXODSN file.
NOTE: If tracing is enabled, the global trace flag is set and from then onwards, all the traceable
ODBC data is logged into the trace file.
To enable tracing for the driver, complete the following steps:
1. Stop the application.
2. Set the TraceStart attribute to 1 in the MXODSN file, and save.
3. Start the application.
To disable tracing, complete the following steps:
1. Stop the application.
2. Set the TraceStart attribute to 0 in the MXODSN file, and save.
3. Start the application.
Setting the MXODSN file path in DSN_PATH
You can specify the MXODSN file path by exporting DSN_PATH environment variable. Accessing
the MXODSN file through DSN_PATH environment variable enables you to access the file from your
selected location. Any error during the process causes the application to exit, and the driver does
not search any other directories.
To export DSN_PATH, enter the following command:
export DSN_PATH=/config/mydsn
where /config/mydsn is the MXODSN file path, excluding the file name.
20 Configuring data sources