Installation under UNIX

Prerequisites:

You must be running a shared libraries build of the extend Interoperability Suite. To check, look at the contents of the lib subdirectory of your ACUCOBOL-GT installation - if the files libruncbl.so/libruncbl.sl or libruncbl64.so/libruncbl64.sl reside in that directory, the runtime is a shared object on your system.

If you intend to connect to a Microsoft SQL Server database, you must have installed the unixODBC (www.unixodbc.org) driver manager, and the driver manager's lib directory is on the LD_LIBRARY_PATH. If you intend connecting to another type of database, as well as the unixODBC driver manager, you can use either the DataDirect (www.progress.com) or iODBC (www.iodbc.org) data managers. In all three instances, refer to the vendor's instructions on how to configure to work with the intended data source.

To install AcuSQL on your UNIX host:

  1. Run the product installer, applying an appropriate product code and product key for AcuSQL, as per the instructions in UNIX Installation.
  2. 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:
    1. In the lib subdirectory of your product installation directory, edit config85.c and set the value of NO_ACUSQL to 0.
    2. Edit Makefile and locate the line that reads:
      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:

      Warning: The library names may vary with different releases by the respective vendors.
      Database type Library name
      DB2 libdb.so
      MySQL libmyodbc3
      MSSQL unixODBC.lib

      On some systems, you may need to ensure that the path to this file is on LD_LIBRARY_PATH; see your operating system documentation for more information on shared libraries.

    3. Also in Makefile, locate the lines:
      ACUSQL_FLAGS = -DNO_ACUSQL=1

      ACUSQL_LIBS = # no acusql runtime libraries are necessary

    4. Relink the pre-compiler by entering the following command:
      make acusql
    5. Move the new acusql executable file into the bin subdirectory of your product installation directory.