dbupdate - Database Update
dbupdate [-fiR] [-I FieldDataFile]
SourceDataArea DestinationDataArea LogFile file
...
dbupdate -V
The dbupdate command retrieves data records from the source data area file using the saved primary key in the log file; 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, then the record is deleted from the destination data area.
In order 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.
| Program Option | Description |
|---|---|
f
|
Fix records, if needed, while copying. |
i
|
Ignore errors while copying. |
R
|
Reject records with bad keys while copying. |
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. FieldOccurrence must be set 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 data types are described in the Doc for Developers: Application Development Workbench Standards. Expressions can be used to specify FieldName. |
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. See the Data Access guide for your database for information about setting up database change logs. |
file ...
|
The name(s) of the file(s) that you want to update. |
V
|
Prints the version of dbupdate. |
At the Qshell command line, specify the information above.
or
-
In a Lawson Interface Desktop (LID) session, use Form Transfer (F8).
-
On Form Transfer, specify dbupdate in the Form ID field. Click the OK button or press Enter.