Testing the Installation

The following procedure uses a shell script on a 32-bit UNIX machine.

1. Export the required environment variables using oalocal.[c]sh. For example, using a shell script on AIX 32-bit:

   $ . oalocal.sh

   $ env | grep ODBC

   ODBCINI=/usr/oaodbclocal810/odbc.ini

   OALOCAL_ODBC_HOME=/usr/oaodbclocal810/lib

2. Use tools/odbcisql to access the installed sample data source named DataSourceName.

   $ tools/odbcisql

3. From the Interactive SQL prompt, run the following isql commands:

   ISQL> CONNECT username*password@mydsn

   ISQL> SELECT * FROM emp;

   ISQL> SELECT * FROM dept;

   ISQL> SELECT * FROM oa_tables;

4. Use admin/oacla.sh to view the configured services.

   $ admin/oacla.sh

5. Run the oacla commands:

   oacla> ServiceList

   oacla> ServiceInfo

   oacla> DataSourceList