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. 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 ACUCOBOL-GT that will create the syb_inst.sql file, which is the collection of stored procedures necessary for executing the Acu4GL interface. You can either (a) use this batch file to create the stored procedures on your Windows NT machine, or (b) copy the stored procedures (syb_inst.sql) from your UNIX client, where they already reside.
If you choose to copy the stored procedures from the UNIX client to the server, then skip Step Three below and proceed to Step Four.
If you choose to execute the batch file on the Windows NT server, then you must copy it (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.
IMPORTANT
You are now ready to use the sql.acu program.
After you learn about and use this utility, you will next find out about preparing and compiling your COBOL program, followed by learning to use the demonstration program.