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 Informix® 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
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
Java application Use SQL commands embedded in a Java program to update databases. Java
Mnemonic
Explanation of References Column
SQLR
Informix® Guide to SQL: Reference
SQLS
Informix® Guide to SQL: Syntax
MG
Informix® Migration Guide
AR
Informix® Administrator's Reference
ESQL/C
Informix® ESQL/C Programmer's Manual
Java
J/Foundation Developer's Guide
DB-A
Informix® DB-Access User's Guide
ER
HCL® Informix® Enterprise Replication Guide
DAPI
Informix® DataBlade® API Programmer's Guide