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.
Using environment variables on UNIX™You can set, unset, modify, and view environment variables. If you already use any HCL OneDB™ products, some or all of the appropriate environment variables might be set.
Syntax for setting environment variables

Syntax for setting environment variables

Use standard UNIX™ commands to set environment variables. The examples in the following table show how to set the ABCD environment variable to value for the C shell, Bourne shell, and Korn shell. The Korn shell also supports a shortcut, as the last row indicates. Environment variables are case-sensitive.


Shell	Command
C	`setenv ABCD value`
Bourne	`ABCD=value export ABCD`
Korn	`ABCD=value export ABCD`
Korn	`export ABCD=value`

The following diagram shows how the syntax for setting an environment variable is represented throughout this chapter. These diagrams indicate the setting for the C shell; for the Bourne or Korn shells, use the syntax illustrated in the preceding table.