To install AcuSQL on your UNIX host:
1. We recommend that you install AcuSQL into your ACUCOBOL-GT home directory. When you install in this way, the AcuSQL libraries and executables are added to the existing ACUCOBOL-GT "bin" and "lib" subdirectories. If you choose to install into a different directory, separate "bin" and "lib" subdirectories are created. You must include the location of the new "bin" directory in the definition of your "path" environment variable. No matter which directory you select for your installation, you must make sure that AcuSQL and ccbl are in the same subdirectory.
2. Insert the installation CD-ROM, floppy disk, or tape into its corresponding device. The instructions for installing from CD-ROM are provided on a Getting Started card supplied with the CD-ROM. If you are installing from floppy or tape, change ("cd") into the target directory and extract the AcuSQL software.
Since the software is in TAR format, use a command similar to the following:
tar xfv device_name
where device_name is the appropriate hardware device on your system (for example, "/dev/rfd0" or "/dev/rmt0"). Follow the instructions on the screen, entering your product code and product key when prompted.
3. Relink the runtime (runcbl) to include your ODBC API library (relinking the runtime requires access to the C compiler supplied by the vendor of your UNIX software; in some cases the C compiler is offered as an add-on option).
a. In the "lib" subdirectory (of the directory into which you installed AcuSQL), edit "config85.c" and set the value of "NO_ACUSQL" to "0".
b. Edit "Makefile" and locate the line:
ACUSQL_ODBC_LIB =
Add the name of your ODBC API library to the end of the line. For example:
ACUSQL_ODBC_LIB = ODBC_lib
where ODBC_lib is the name of your ODBC API library.
c. Also in "Makefile", locate the lines:
ACUSQL_FLAGS = -DNO_ACUSQL=1 ACUSQL_LIBS = # no acusql runtime libraries are necessary
Make sure that the above lines are commented out (use the comment character "#").
Next, locate the lines:
#ACUSQL_FLAGS = #ACUSQL_LIBS = $(ACU_LIBDIR)/libesql.a $(ACUSQL_ODBC_LIB)
Make sure that the above lines are un-commented (remove the comment character "#").
Save and close "Makefile".
d. Relink the runtime system by entering "make runcbl" on the command line.
If you get unresolved reference errors that refer to your ODBC library, you will need to further modify the "Makefile" to include the needed libraries (see your ODBC API documentation). Such libraries can be added to the end of the LDFLAGS lines, or at the end of the list for "runcbl" and "acusql".
e. Move the new runcbl executable file into the "bin" directory.
4. If you plan to use the pre-compiler mode that connects directly to your database engine to verify the SQL syntax, you must relink acusql to include your ODBC API libraries.
a. If you haven't already done so, perform steps "a" and "b" of item 3 above.
b. Relink the pre-compiler by entering "make acusql" on the command line.
c. Move the new acusql executable file into the "bin" directory.