Complete the following steps to install the interface on a Windows NT server machine.
Step One: Install SQL Server
Sybase, version 10.0 or later, must be installed and configured on the Windows NT server machine before you install Acu4GL for Sybase on the client machine. Follow the instructions from your RDBMS vendor.
The ISQL product, which is an interactive query tool, is also necessary for installing the ACUCOBOL-GT stored procedures.
The Acu4GL interface does not need ISQL after installation, but it is a tool that will 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.
These products are not provided by Acucorp.
Step Two: Copy the batch file
The file syb_inst.cmd is a batch file from Acucorp that will create the syb_inst.sql file, which is the collection of stored procedures necessary for executing the Acu4GL interface. Copy syb_inst.cmd to your server machine into a directory of your choice.
Step Three: Execute the batch file
To execute the batch file, enter
SYB_INST LockDatabase
where LockDatabase is the database you want to use for the internal ACUCOBOL-GT lock tables. If this database does not already exist, it will be created.
Everyone who will use the Acu4GL for Sybase interface will need to have write access to this database.
This step creates syb_inst.sql, which is the collection of stored procedures necessary for executing the Acu4GL interface.
Step Four: Install the ACUCOBOL-GT stored procedures
You must have database administrator privileges to do this step. You need to enter the password for the database administrator.
Type:
ISQL -USA -Ppassword < SYB_INST.SQL
Another way to accomplish the same result is to use ISQL/W to execute syb_inst.sql as a query. See your Sybase documentation for how to do this.
This completes the setup on the Windows NT server machine. You are now ready to complete the installation on the client machine.