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.
TABLE menu optionsThe TABLE menu options for the dbaccess command represent short cut keys for the TABLE menu.

TABLE menu options

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

-ta

Chooses the Alter option on the TABLE menu.

-tc

Chooses the Create option on the TABLE menu.

-td

Chooses the Drop option on the TABLE menu.

-ti

Chooses the Info option on the TABLE menu. With this option, you can add another letter as shown in the following list (and specify a table) to go to the next menu level and view:

-tic: Columns in the table
-tif: Information about fragmentation strategy for the table
-tig: Information about triggers in the table
-tii: Indexes on the table
-tio: Table constraints
-tip: Access privileges on the table
-tir: Table-level references privilege on the table
-tis: Table status information

If you do not include a table name with the -ti option, you must choose one from the INFO FOR TABLE screen.

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

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.