Testing Basic Operations

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

1. Export the required environment variables using oalocal.sh

   $ . oalocal.sh
   $ env | grep ODBC
   ODBCINI=/usr/oaodbclocal/odbc.ini
   OALOCAL_ODBC_HOME=/usr/oaodbclocal/lib
   

2. Use tools/odbcisql to access the installed sample data source named DataSourceName. DataSourceName is a predefined ODBC data source that is defined in ODBC.ini.

   $ tools/odbcisql

3. From the ISQL 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