IBM® Informix® 12.10

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 IBM® 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
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 IBM Informix .	GM, GU

Mnemonic: Explanation of References Column
SQLR: IBM Informix Guide to SQL: Reference
SQLS: IBM Informix Guide to SQL: Syntax
MG: IBM Informix Migration Guide
AR: IBM Informix Administrator's Reference
GM: IBM Informix Enterprise Gateway Manager User Manual
GU: IBM Informix Enterprise Gateway User Manual
DBDK: IBM DataBlade® Developers Kit User's Guide
ESQL/C: IBM Informix ESQL/C Programmer's Manual
Java: J/Foundation Developer's Guide
HPL: IBM Informix High-Performance Loader User's Guide
DB-A: IBM Informix DB-Access User's Guide
ER: IBM Informix Enterprise Replication Guide
DAPI: IBM Informix DataBlade API Programmer's Guide

Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.

Release date: March 2014