dbu2sql

Index Home Arana > Arana Architecture > Arana Utilities > dbu2sql

dbu2sql

This command is used to update specific database record fields. The DBU file specifies the changes to make; running this command converts those changes to SQL.

The command syntax is:

dbu2sql dbufilename

DBU file format

The format is line oriented.

Comment lines begin with #.

The database table to modify must be specified first; it is specified inside square brackets, for example

[Item]

The record to modify is found by matching a field with a specific value.  The line must begin with a greater than symbol, followed by the search field name, then equals sign, then value. It may optionally be followed by a space and another field=value term.  For example,

>Keyword="belt"

One or more lines may follow, specifying new values for specific fields.  The tab indented field name is followed by the equals sign and the new value.  For example,

   Codes="[wear]=waist"

After the changes, another record can be searched with its changes asserted as well.  As many record changes may be specified as desired.