dbload

Load database from flat file
dbload [-anrf] dataarea|dataID [filename] flatfilename
Load a flat file into a database file. The only format it accepts is dbdump -d

Option Description

a Overwrite all duplicate records. Replaces existing database records with duplicate records in the flat file. If the flat file has multiple occurrences of a record, the last occurrence is stored in the database.

n Do not overwrite duplicate records. Does not replace existing database records with duplicate records from the flat file. It ignores the duplicate records in the flat file.

r Report on duplicate records. If there are duplicate records between the flat file and the database, prints them. It does not replace the existing database records.

f Do not check for existing records. Required for SQL databases. Writes whatever records exist in the flat file, completely overwriting the records in the database.

Option	Description
a	Overwrite all duplicate records. Replaces existing database records with duplicate records in the flat file. If the flat file has multiple occurrences of a record, the last occurrence is stored in the database.
n	Do not overwrite duplicate records. Does not replace existing database records with duplicate records from the flat file. It ignores the duplicate records in the flat file.
r	Report on duplicate records. If there are duplicate records between the flat file and the database, prints them. It does not replace the existing database records.
f	Do not check for existing records. Required for SQL databases. Writes whatever records exist in the flat file, completely overwriting the records in the database.