dbload - Load a Database from a Flat File

dbload [-7anrf] 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.
7 Indicates that the flat file is in Lawson 7.x format for IBM i.

At the Qshell command line, specify the information above.

- or -

  1. In a Lawson Interface Desktop (LID) session, use Form Transfer (F8).

  2. On the Form Transfer form, specify dbload in the Form ID field. Click the OK button or press Enter.

  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.