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.
Start DB-AccessYou start DB-Access by running the dbaccess command from the command line. You can choose whether to use the DB-Access menu interface or the command-line interface.
dbaccess command: Start DB-AccessUse the dbaccess command to start DB-Access. Include options to specify the database, command files, or to go to a specific menu screen.
DATABASE menu optionsThe DATABASE menu options for the dbaccess command represent short cut keys for the DATABASE menu.

DATABASE menu options

The DATABASE menu options for the dbaccess command represent short cut keys for the DATABASE menu.

-dc

Chooses the Create option on the DATABASE menu.

-dd

Chooses the Drop option on the DATABASE menu.

-di

Chooses the Info option on the DATABASE menu. With this option, you can add another letter as follows to go to the next menu level and view:

If you do not include a database name before any -di option, you must choose a current database from the SELECT DATABASE screen.

-dl

Chooses the CLose option on the DATABASE menu.

-ds

Chooses the Select option on the DATABASE menu.