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: Show nonprintable characters in hexadecimalThis example starts DB-Access and activates the hexadecimal load and unload format (XLUF) so that the LOAD and UNLOAD SQL statements can format nonprintable ASCII signs in hexadecimal format.

Example: Show nonprintable characters in hexadecimal

This example starts DB-Access and activates the hexadecimal load and unload format (XLUF) so that the LOAD and UNLOAD SQL statements can format nonprintable ASCII signs in hexadecimal format.

The following command activates the XLUF format for the mystores database:

dbaccess -X mystores

A .unl file that the UNLOAD statement produces contains the hexadecimal format changes.

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.