Using the sql.acu Program

Micro Focus provides a utility program that gives you access to some of the standard SQL commands. Once you have compiled sql.cbl, it can be called from a COBOL program or executed from the command line. This file is located in the acu4gl sub-directory of your sample directory.

As a general rule, sql.acu may be used to issue all SQL commands except those that perform data retrieval. The sql.acu program cannot perform statements that return data, such as the SELECT statement. This category of statements returns an error when passed to the sql.acu program.

The global variable return-code is 0 when a command has completed successfully. If a command is not successful, return-code contains an error code.