Updating Lawson Data Between Data Areas with dbupdate

The dbupdate command retrieves data records from the source data area file using the saved primary key in the log file. It then converts, inserts, or updates records in the destination data area file to match the source data area file. If a record exists in the destination data area but is not found in the source data area, the record is deleted from the destination data area.

For dbupdate to process a file, the number, names, and order of fields in the primary keys for the specified files in the source and destination data areas must match. Field types and sizes do not need to be identical, as long as the field values can be converted.

To update data

At a command prompt, type:

dbupdate [-fiR] [-I FieldDataFile] SourceDataArea DestinationDataArea LogFile file ...

where the following program options may be used.

Program Option Description
-f If needed, fix records while copying.
-i Ignore errors while copying.
-R Reject records with bad keys while copying.
-I FieldDataFile

Read in data to initialize specified fields in the destination file. Each row represents one field to be initialized with the value specified.

The format for the data in FieldDataFile is:

FileName FieldName FieldOccurrence FieldValue

The data in FieldDataFile may be space, tab, or comma-delimited. Each entry (row) is delimited by a new line character.

Note: If FieldName in FieldDataFile exists in both source and destination data areas, then the corresponding FieldValue overrides the value read in from the source database.
FileName The file in the destination data area that this row contains a default value for.
FieldName The name of a field in FileName that this row contains a default value for.
FieldOccurrence The number of times FieldName occurs. Set this option to 1 (one) or higher.
FieldValue The default value you want to populate FieldName . The value must be conform to the standard format for each field data type. Valid Lawson data types are described in the Lawson Doc for Developers: Application Development Workbench.
SourceDataArea The data area containing the file whose values you want to use to update the file in the destination data area.
DestinationDataArea The data area containing the file that you want to update.
LogFile The file that recorded changes to the database. Configuring Database Change Logs for dbupdate
file ... The name(s) of the file(s) that you want to update.
-V Prints the version of dbupdate.