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.

-dcl: Takes you to the LOG option on the CREATE 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:

-dib: The dbspaces information for the current database
-din: The NLS information for the current database
-dip: Stored procedures in the current database

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.

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.