c-treeACE V11.0 Update Guide

c-treeACE SQL SETENV limit raised to 8192

c-treeACE SQL server did not start when ctsrvr.cfg contained a SETENV configuration referencing an environment variable evaluating to more than 1024 bytes.

Previously two limits were enforced in setting environment variables in ctsrvr.cfg:

1. While parsing ctsrvr.cfg - Limit of 1024 bytes to hold the content of ctsrvr.cfg and expand the environment variables referenced (an error was returned if the expanded value did not fit)
2. When storing the variable name and content for SQL usage - Limit of 50 bytes for the environment variable name and 255 bytes for the content (name/value truncated if it did not fit)

Limit #1 has now been increased to 8192

Limit #2 has been removed with dynamic memory allocation.

The net effect is a practical limit is 8192 bytes.

c-treeACE SQL Stored Procedure Server-side Debugging Options

In V11 and later, server-side stored procedure execution logging can be turned on and off using the TPESQLDBG environment variable. TPESQLDBG is an array of 'Y'/'N' characters that determine which debug options are enabled.

Prior to this revision, this was achieved by setting the 11th element (offset 10, java_debug) in the TPESQLDBG environment variable. The logging produced in this way is quite verbose and included information that was useful only to FairCom Technicians.

The interpretation of TPESQLDBG (and other methods setting the same debug features) has been modified as follows:

• TPESQLDBG (which was an array of 12 'Y'/'N' characters) has been expanded to 13 elements.
• The element at offset 12 is a new element named stp_logging that controls the log() method used in stored procedures to generate log messages.

Note that activating element #11 (java_debug) activates internal logging and log() method for ANY stored procedure language, not just Java.