Testing Using the memory IP C Example

The following procedure uses a shell script on a 64-bit AIX machine.

1. Build the memory IP C example.

   $ . ip/cfg/setenv.sh
   OpenAccess Environment Configuration
   Build: RELEASE (Unicode)
   Platform: raix
   Root: /usr/oaodbclocal900
   Makefile: /usr/oaodbclocal900/ip/cfg/env.mk
   $ ( cd ip/oac/memory ; make )
   ....
   ==== /usr/oaodbclocal900/ip/bin/oadamipmem.so built successfully ====
   

2. Create a new data source. Duplicate the sample data source DataSourceName and set ServerDataSource to memory.

   $ vi $ODBCINI

   [ODBC Data Sources]
   MemoryCExample= DataDirect OpenAccess SDK 9.0 - Local
   [MemoryCExample]
   Driver=/usr/oaodbclocal900/lib64/ivoal27.so
   Description=Memory Ip C example
   Host=/usr/oaodbclocal900/cfg/oadm.ini
   Port=OpenAccessSDK900_C
   ServerDataSource=memory
   CustomProperties=
   

3. Use tools/odbcisq to test the data source MemoryCExample.

   $ tools/odbcisql

   ISQL> connect pooh*bear@MemoryCExample

   ISQL> SELECT * FROM emp;

   ISQL> SELECT * FROM dept;

   ISQL> SELECT * FROM oa_tables;