InstantSQL Components

Components

In addition to this help file, InstantSQL has compile-time and run-time components.

The compile-time components are the following set of copy files:

lisqlall.cpy ‑ This copy file is the main copy file for implementing InstantSQL in an RM/COBOL source program. The source program should include this copy file with a COPY statement at the beginning of the Working-Storage Section. This copy file copies the remaining copy files used by InstantSQL. In those cases where the RM/COBOL source program already uses a REPLACE statement, it may be necessary to use the copy files lisqlrpl.cpy and lisqldef.cpy directly instead of using this copy file.

lisqldcl.cpy ‑ This copy file provides the data description entries for the non-extended column description group returned by the SQL DESCRIBE COLUMN statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Column-Description. In programs where it is desired to have a set of column description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

lisqldcn.cpy ‑ This copy file provides the data description entries for the non-extended connection description group returned by the SQL DESCRIBE CONNECTION statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Connection-Description. In programs where it is desired to have a set of connection description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

lisqldef.cpy ‑ This copy file provides the definitions of various constants and data items necessary for using InstantSQL in a COBOL source program. This copy file also contains a brief form of reference documentation for InstantSQL.

lisqlder.cpy ‑ This copy file provides the data description entries for the error description group returned by the SQL DESCRIBE ERROR statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Error-Description. In programs where it is desired to have a set of error description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

lisqldpm.cpy ‑ This copy file provides the data description entries for the parameter description group returned by the SQL DESCRIBE PARAMETER statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Param-Description. In programs where it is desired to have a set of parameter description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

lisqldqy.cpy ‑ This copy file provides the data description entries for the error description group returned by the SQL DESCRIBE QUERY statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Query-Description. In programs where it is desired to have a set of query description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

lisqlrpl.cpy ‑ This copy file provides the REPLACE statement entries that convert InstantSQL statements in the COBOL source program to CALL statements. In RM/COBOL programs that already use a REPLACE statement, it may be necessary to copy this file into an existing REPLACE statement instead of using the lisqlall.cpy file, which provides the necessary REPLACE statement.

lisqlxcl.cpy ‑ This copy file provides the data description entries for the extension portion of an extended column description group returned by the SQL DESCRIBE COLUMN statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Column-Description-Ext. In programs where it is desired to have a set of extended column description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

lisqlxcn.cpy ‑ This copy file provides the data description entries for the extension portion of an extended connection description group returned by the SQL DESCRIBE CONNECTION statement. The copy file lisqldef.cpy includes one copy of this file in the group named sql-Connection-Description-Ext. In programs where it is desired to have a set of extended connection description groups, additional copies of this file are useful following a COBOL table definition using the OCCURS clause to define as many entries as desired.

The run-time components are the dynamic link library (DLL) and configuration files as follows:

lisql.dll ‑ This DLL supports the calls made by an RM/COBOL program that uses InstantSQL statements. The DLL must be available at run time, either through the RUNPATH environment variable or by using the runtime command option l. On UNIX systems, the shared object file lisql.so is used instead.

lisql.reg ‑ This registry input file provides the configuration options used by InstantSQL at run time from the registry. The values must be entered into the registry by running the Windows regedit program on this file or, equivalently, by double clicking this file from the Windows Explorer. The file may be edited to modify the settings of any of the configuration options and re-entered into the registry at any time. Only the registry settings at start up of an InstantSQL application affect that run unit of the application. See the topic InstantSQL Configuration for a description of the configuration options.