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: Run a command fileThis example shows how to start DB-Access and run a command file that contains SQL statements.

Example: Run a command file

This example shows how to start DB-Access and run a command file that contains SQL statements.

The following sample command runs the SQL statements in a file named sel_stock.sql on the mystores database:

dbaccess mystores sel_stock

The following sample command runs the SQL statements in the sel_all.sql file on the database that file specifies:

dbaccess - sel_all.sql

Some operating systems require that you have execute permissions to run SQL command files, read permissions to open these files or their contents in DB-Access, or write permissions to save modified or new files.

Use the UNIX™ chmod command to enable execution of the SQL files that the initialization script installed.