dbload - Load a Database from a Flat File

dbload [-anrf] dataarea|dataID filename [flatfilename]

Load a flat file into a database file. The only format it accepts is dbdump -d. See dbdump - Dump Database File

Program 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 that prints duplicate records between the flat file and the database. 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.

At the command line, specify the information above.

- or -

  1. From the Database Administration menu, choose Data Export/Import.

  2. From the Data Export/Import menu, choose Load Database From Flat File.

  3. Specify or select the following data.

    Program Options
    See program options above.
    Product Line
    The dictionary (product line) you are loading the flat file to.
    File Name
    The file you want to load. Leave blank to load the entire database
    Flat File Name
    The flat file to load database files from.
    I/O Options
    Optional. Display the output or redirect it to a file.

  4. Press Enter.

Note: Date, time, user name, type, utility name, and key field activities of this utility are logged in the $LAWDIR/system/secadmin.log file.