Populate the database
For your initial tests, the easiest way to populate the
database is to type INSERT statements in DB-Access.
For example, to insert a row into the manufact table of the
demonstration database, enter the following command in DB-Access:
INSERT INTO manufact VALUES ('MKL', 'Martin', 15);If you are preparing an application program, such as an application in C, you can use the application to enter rows into a database table.
The
following table lists HCL®
OneDB® tools
that you can use for entering information into your database. The
acronyms in the Reference column are explained after the table.
| Tool | Purpose | Reference |
|---|---|---|
| dbaccessdemo | Prepare and populate sample databases. | DB-A, SQLR |
| DB-Access | Edit a database by entering explicit commands. | DB-A, SQLS |
| onunload & onload | Copy an entire database or selected database tables to or from files on tape or disk. | MG, AR |
| dbload | Load data from one or more text files into one or more existing tables. | MG |
| High-Performance Loader | Copy an entire database, selected tables, or selected columns of selected tables. | HPL |
| LOAD & UNLOAD | Load data from (or into) a text file. | SQLS |
| dbexport , dbimport | Copy an entire database using text files. | MG |
| Enterprise Replication | Update selected databases each time a specified table is updated. | ER |
| C application | Use SQL commands embedded in a C program to update databases. | ESQLC, DAPI, DBDK |
| Java™ application | Use SQL commands embedded in a Java program to update databases. | Java, DBDK |
| Gateway applications | Access data from databases that are not HCL OneDB . | GM, GU |
- Mnemonic
- Explanation of References Column
- SQLR
- HCL OneDB Guide to SQL: Reference
- SQLS
- HCL OneDB Guide to SQL: Syntax
- MG
- HCL OneDB Migration Guide
- AR
- HCL OneDB Administrator's Reference
- GM
- HCL OneDB Enterprise Gateway Manager User Manual
- GU
- HCL OneDB Enterprise Gateway User Manual
- DBDK
- HCL OneDB DataBlade® Developers Kit User's Guide
- ESQL/C
- HCL OneDB® ESQL/C Programmer's Manual
- Java
- HCL J/Foundation Developer's Guide
- HPL
- HCL OneDB High-Performance Loader User's Guide
- DB-A
- HCL OneDB DB-Access User's Guide
- ER
- DAPI
- HCL OneDB DataBlade API Programmer's Guide