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.
LD_LIBRARY_PATH environment variable (UNIX™)

LD_LIBRARY_PATH environment variable (UNIX)

The LD_LIBRARY_PATH environment variable tells the shell on Solaris systems which directories to search for client or shared HCL OneDB™ general libraries. You must specify the directory that contains your client libraries before you can use the product.

pathname: Specifies the search path for the library.

For INTERSOLV DataDirect ODBC Driver on AIX®, set LIBPATH. For INTERSOLV DataDirect ODBC Driver on HP-UX, set SHLIB_PATH.

The following example sets the LD_LIBRARY_PATH environment variable to the directory:

setenv LD_LIBRARY_PATH
${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/esql:$LD_LIBRARY_PATH