Use dfdbconf and dfdbview for UNIX and Linux ODBC Connections

Follow these steps to create ODBC connections with required stored credentials in the UNIX and Linux ODBC operating environments:
  1. Execute the following command:
    install-path/bin/dfdbconf
  2. Select a driver from the list of available drivers.
  3. Set the appropriate parameters for the driver. The new data source is added to the odbc.ini file, which is stored at install-path/etc.
    Note: You can also use dfdbconf to delete the data sources.
  4. Add stored credentials to the data source by executing the following command:
    install-path/bin/dfdbview -s data-source-name
  5. Test the new data source by executing the following command:
    install-path/bin/dfdbview data-source-name
  6. If the connection succeeds, use the prompt to enter SQL commands to test the connection. If the connection fails, resolve the errors described in the error messages.