UNIX Server Machine Installations

To install the Acu4GL for Sybase on a UNIX server machine:

Step 1: Install Sybase

The Sybase RDBMS, version 11.0 or later, must be installed and configured before you install Acu4GL for Sybase. Follow the Sybase installation instructions in your Sybase documentation.

Sybase’s isql product, which is an interactive query tool, is also necessary for installing the ACUCOBOL-GT stored procedures.

The Acu4GL product does not need isql after installation, but it’s a tool that can give you quite a bit of flexibility. It allows you to do database work outside of COBOL, including interactive queries, table creation, table modification, and creation of views, constraints, and relationships between tables.

Micro Focus does not provide these products.

Step 2: Copy files

Copy “syb_inst”, “syb_cfg.in”, and “syb_inst.in” to your UNIX server machine.

Step 3: Create stored procedures

The file “syb_inst” is an interactive shell script that generates the SQL script used to install ACUCOBOL-GT stored procedures.

Execute the shell script “syb_inst” by entering the following command on your server machine:

sh  syb_inst  
Note:

You may exit the script at any time by pressing the system interrupt key (usually CTRL+C).

If you entered only syb_inst instead of the full command, this message may appear:

VAL=0: command not found
VAL:  Undefined variable

This can be fixed by entering sh syb_inst.

When the script begins executing, you will see the following message:

During the execution of this script, we will create an SQL script which you will need to execute from isql, using a command like:
  
"isql -Usa -Ppassword < syb_inst.sql"
  
This script will add some stored procedures, and create some tables in a database that you specify during the execution of this script.

In order to implement locking from ACUCOBOL-GT, we need to create a lock table. This should be a pretty small table, but we need to decide which database to create this table in. You should now enter the name of the database you want the lock tables created in. If the database does not exist, it is created.

The following question is asked until you enter a valid database name:

Which database would you like to create this table in?

This database will eventually be located on your server machine. Enter a valid database name. (Invalid names are master, model, temp, or sybsystemprocs.) Names must start with a letter or underscore, must contain only letters, digits, and underscores, and may be up to 30 characters long. Any other entry will be modified.

Next you see the following message:

Saving any old version of syb_inst.sql...

Old versions of “syb_inst.sql” are saved to “syb_instnnn.sql” where nnn starts at 001 and goes to 999. If a file “syb_inst.sql” exists, you see:

Saving syb_inst.sql as syb_instnnn.sql

for some value of nnn. Then you see:

Creating syb_inst.sql...

This uses the file “syb_inst.in” as a template, and creates “syb_inst.sql”, using the database name you entered above.

You also see:

Creating cblconfig.syb...

This is a sample file of configuration variables you may want to add to your cblconfig file.

You then see the following message:

Do you want to set up the Makefile for this system?

Type n or N to quit the script.

Step 4: Install the ACUCOBOL-GT stored procedures

You must have Database Administrator privileges to install the ACUCOBOL-GT shared procedures on the server. (You need to enter the password for the Database Administrator.) Enter the following command:

isql -Usa -Ppassword  <  syb_inst.sql

By default, the stored procedures are installed into the master or sybsystemprocs databases. However, you may choose another database in which to store them. Follow these steps if you want to install the stored procedures in a database other than the default:

  1. Before you execute the “syb_inst.sql” query, modify the query file to use the desired database instead of the master or sybsystemprocs database. After you have modified the query file, execute it as described above.
  2. Create in each database that contains tables accessed by Acu4GL the stored procedures that were previously in the master or sybsystemprocs database. Note that the stored procedures are executed without being prefixed by a database name, and Sybase requires that such stored procedures must be in the master or sybsystemprocs database.

The interface also searches for and executes the sp_AcuInit stored procedure from this location. This stored procedure is executed when a connection is made to the database; therefore, sp_AcuInit should reside in the default database for each user if it is not created in the master database. See Built-in Stored Procedures for information on the sp_AcuInit stored procedure.

This completes the setup on the UNIX or Windows server machine.

Note: If you are updating from an earlier version of Acu4GL, be sure to install the new stored procedures. We always update stored procedures in such a way that they are compatible with older versions of the product, so installing new stored procedures over old ones does not affect your ability to run with an older version of the interface software. Your new version of Acu4GL for Sybase may not run properly without the corresponding stored procedures.

It can be difficult to maintain multiple copies of stored procedures; therefore, We recommend that you continue to create the stored procedures in the master or sybsystemprocs database. If your installation does not permit this, you do have the flexibility to create the stored procedures elsewhere. However, to facilitate maintenance of the stored procedures, We recommend that you create as few databases as possible.