PRB: ESQL: R6009 - Out of Environment Space

  - Microsoft Embedded SQL version 4.2 for COBOL

SYMPTOMS

When running an Embedded SQL for COBOL MS-DOS application that either links with COBLIB or is compiled into a .GNT file, the program reports the following error:

   R6009 - out of environment space

CAUSE

The COBOL run-time system, either COBLIB or the Micro Focus resident run- time system, needs to know at startup how much memory should be freed back to the application for use by non-COBOL code. Since the library that handles the SQL Server connections was written in C, it is not allowed any memory for dynamic allocation at run time. When this library attempts to allocate memory for connection and query management, it fails and returns the error listed above.

WORKAROUND

The environment variable COBPOOL will tell the run-time system how much memory to leave the program for non-COBOL functions. This variable is documented in the "Microsoft COBOL Operating Guide" and indicates how many kilobytes of memory should be freed. This number will depend on the number of connections in the program as well as query size. The following command will work for a very small program such as SQLDOS, which shipped with the Embedded SQL for COBOL package:

   SET COBPOOL=10