c-treeACE SQL can set environment variables for the server process on startup. This functionality is implemented via the keyword SETENV.For example, the c-treeACE SQL looks at the CLASSPATH to find required classes for proper operation of the server. When the c-treeACE SQL is running as a Windows 32 bit versions Service, c-treeACE SQL is launched automatically by the SCM (Service Control Manager) when the computer starts up. Setting the CLASSPATH via a keyword eliminates the manual operation of setting environment variables. The syntax is as follows:
Where var is the environment variable and value is the setting. For example:
The input line length for the server configuration file is 1024 to allow for very long configuration values.
The c-treeACE SQL considers existing environment variables during startup processing for the Java environment used with stored procedures. The following variables are used in the c-treeACE SQL configuration file, ctsrvr.cfg, to set the parameters for the Java JVM and compiler. These configurations are required for c-treeACE SQL Stored Procedures, Triggers, and User Defined Functions:
When these values are not explicitly set within the server configuration file, the server considers existing system environment variables.This feature simplifies setup and configuration changes for c-treeACE SQL Stored Procedures. Refer to the Appendix Server Configuration Keywords for a complete list of c-treeACE SQL specific keywords.