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.
Example: View the Information SchemaThis example shows how to start DB-Access and view the Information Schema for the specified database.

Example: View the Information Schema

This example shows how to start DB-Access and view the Information Schema for the specified database.

The xpg4_is.sql file in the $ONEDB_HOME/etc directory creates the Information Schema and installs the views for a specified database. The following command creates the Information Schema for database mystores:

dbaccess mystores $ONEDB_HOME/etc/xpg4_is.sql

The Information Schema adds to the database four information-only views that conform to X/Open XPG4 with HCL® OneDB® extensions. After you run xpg4_is.sql, use DB-Access to retrieve information about the tables and columns that you have access to in the specified database.

Tip: Do not install XPG4-compliant views on an ANSI database, because the format of XPG4-compliant views differs considerably from the format of the ANSI-compliant Information Schema views that are defined by the SQL standards committee.

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.