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.
ISM_ENCRYPTION environment variableUse the ISM_ENCRYPTION environment variable in the ON-Bar environment to specify whether HCL® OneDB® Storage Manager uses data encryption.

ISM_ENCRYPTION environment variable

Use the ISM_ENCRYPTION environment variable in the ON-Bar environment to specify whether HCL® OneDB® Storage Manager uses data encryption.

Three settings of ISM_ENCRYPTION are supported:

XOR: Uses encryption.
NONE: Does not use encryption.
TRUE: Uses encryption.

If ISM_ENCRYPTION is set to NONE or is not set, the ISM server does not use encryption.

If the ISM_ENCRYPTION is set to TRUE or XOR in the environment of the ON-Bar process that makes a request, the ISM server uses encryption to store or retrieve the data specified in that request.