Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Environment variablesVarious environment variables affect the functionality of your HCL OneDB™ products. You can set environment variables that identify your terminal, specify the location of your software and define other parameters.
Environment variables in HCL OneDB™ productsThe topics that follow discuss (in alphabetic order) environment variables that HCL OneDB™ database server products and their utilities use.
INTERACTIVE_DESKTOP_OFF environment variable (Windows™)

INTERACTIVE_DESKTOP_OFF environment variable (Windows)

This environment variable lets you prevent interaction with the Windows™ desktop when an SPL routine executes a SYSTEM command.

If INTERACTIVE_DESKTOP_OFF is 1 and an SPL routine attempts to interact with the desktop (for example, with the notepad.exe or cmd.exe program), the routine fails unless the user is a member of the Administrators group.

The valid settings (1 or 0) have the following effects:

1: Prevents the database server from acquiring desktop resources for the user executing the stored procedure
0: SYSTEM commands in a stored procedure can interact with the desktop. This is the default value.

Setting INTERACTIVE_DESKTOP_OFF to 1 allows an SPL routine that does not interact with the desktop to execute more quickly. This setting also allows the database server to simultaneously call a greater number of SYSTEM commands because the command no longer depends on a limited operating- system resource (Desktop and WindowStation handles).