Created On:  22 October 2012

Problem:

InstantSQL requires that an ODBC Driver Manager be available, however, most Unix distributions do not come, by default, with one installed.

Resolution:

There are two different ODBC Driver Managers that are supported on Unix.  Below are instructions for setting up your UNIX environment for use with InstantSQL and the two different ODBC driver managers:


iODBC Driver Manager:

1. Obtain iODBC Driver Manager from http://www.iodbc.org. Follow the instructions at the site to build and/or install the package.

2. Set your OS's library search path to include the directory containing the iODBC Driver Manager libraries(iodbc_lib_path):

• IBM AIX - export LIBPATH=$LIBPATH:iodbc_lib_path
• HP-UX - export SHLIB_PATH=$SHLIB_PATH:iodbc_lib_path
• Intel UNIX System V Release 4, Linux, SCO OpenServer 5, SCO System V Release 5 (UnixWare 7.1.1 or later and SCO OpenServer 6), and Sun Solaris SPARC and Intel x86 - LD_LIBRARY_PATH=$LD_LIBRARY_PATH:iodbc_lib_path

3. Set the ODBCINI environment variable to point to your Driver Manager's odbc.ini file:

export ODBCINI=odbc_ini_file_path


unixODBC Driver Manager:

1. Obtain unixODBC Driver Manager from http://www.unixodbc.org/.  Follow the instructions at the site to build and/or install the package.

2. Set your OS's library search path to include the directory containing the unixODBC Driver Manager libraries(unixodbc_lib_path):

• IBM AIX - export LIBPATH=$LIBPATH:unixodbc_lib_path
• HP-UX - export SHLIB_PATH=$SHLIB_PATH:unixodbc_lib_path
• Intel UNIX System V Release 4, Linux, SCO OpenServer 5, SCO System V Release 5 (UnixWare 7.1.1 or later and SCO OpenServer 6), and Sun Solaris SPARC and Intel x86 - LD_LIBRARY_PATH=$LD_LIBRARY_PATH:iodbc_lib_path

3. Set the ODBCINI environment variable to point to your Driver Manager's odbc.ini file:

export ODBCINI=odbc_ini_file_path

4. Create the following symbolic link in the unixODBC "lib" directory:

ln -s libodbc.so libiodbc.so.2


Once you have installed your chosen ODBC Driver Manager, then, you can load the InstantSQL module(libisql.so) using the "L" command line option.  For example:

runcobol queryds l=/usr/rmcobol/InstantSQL/libisql.so


Please contact Micro Focus Customer Care if you encounter any issues setting up your Unix environment for use with RM/COBOL and InstantSQL.