dbdump - Dump Database File

dbdump [-dp] [-i index] dataarea|dataID filename [> flatfile]

Dump database files to standard output. You can then load the database from the flat file using dbload. Do not use this utility to import data into a Lawson database from a non-Lawson application system. The main use for this utility is to dump the Lawson database on one machine and load it onto another.

Unless you use the -d option, the utility truncates fields larger than 80 columns (or 132 columns, with the -p option). To dump files containing fields larger than 80 columns, in addition to using dbdump -d, you can also use rngdbdump with either the -d or -c option.

If your data files have attachments, make sure you dump both the header and detail attachment files. They reside in the same data area as the data to which they are attached, and they are named as follows:

L_HPrefix L_DPrefix

where the following values apply:

Value Description
Prefix The prefix of the data file the attachments are related to.
L_H A header attachment file. If the file name is EMPLOYEE, for example, the result is L_HEMP. The header is in the first 512 bytes of the attachment.
L_D The detail attachment file. This makes up the remaining bytes (up to 32,000) of the attachment.
Note: To have the system automatically dump and load the attachment files, use the expsysdb and impexp utilities.
Program Option Description
d Dump to a flat file. Use with the dbload utility. You can also use this option to dump files containing fields larger than 80 columns.
p Printer format (132 columns). Writes the output in 132-column format. The default is to write the output in 80-column format for online display.
i Use index (for example, -iGLMSET1). Dumps the database using an index sequence. The index name must follow the -i.

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 Dump Database File.

  3. Specify or select the following data.

    Program Options
    See the program options listed above.
    Dictionary Name

    Dictionary (data area) whose database files you want to dump.

    File Name
    File you want to dump.
    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.