PRB: R6009 - Out of Environment Space in ESQL for COBOL

ID Number: Q72943

1.10 1.11 4.20

OS/2

Summary:

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.

RESOLUTION

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

This allows 10K to be used for non-COBOL functions, such as the

Embedded SQL for COBOL functions that need to dynamically allocate

memory.

Additional reference words: Embedded SQL for COBOL