Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
DB-Access User's GuideThis publication describes how to use the DB-Access utility to access, modify, and retrieve information from HCL® OneDB® database servers.
Getting started with DB-AccessDB-Access provides a menu-driven interface for entering, running, and debugging Structured Query Language (SQL) statements and Stored Procedure Language (SPL) routines. You can also run DB-Access interactively from the command line.
Requirements for the HCL OneDB™ Client Software Development Kit DB-Access utilityBefore you start DB-Access on a client, set up the client environment.

Requirements for the HCL OneDB Client Software Development Kit DB-Access utility

Before you start DB-Access on a client, set up the client environment.

The DB-Access utility on a client can directly access HCL OneDB™ databases with which Client SDK has a client/server connection.

Do the following tasks before you start DB-Access utility that is included with Client SDK:

Set the client/server connectivity information in the sqlhosts file.
- If you renamed the file or moved it from the default location, set the ONEDB_ SQLHOSTS environment variable to the full path name and file name of the file that contains the connectivity information.
- You can use the syncsqlhosts utility to convert connection information from the Windows™ registry format to the sqlhosts file format.
Set the sqlhosts information.
Set the ONEDB_HOME environment variable to the Client SDK installation directory.
Set the ONEDB_SERVER environment variable for a default server name.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.