|
rngdbdump
Dump Database File Range
rngdbdump [-ctnd] [-iindex] dataarea|dataID filename [-f fieldname…] [-k rangekey…] -v fieldvalue...]
Dump a selection of records from one database file to standard output. Based
upon the primary index of the file or an index you specify, you can extract all
the fields in a record, or any combination of fields. You can control the range
of records selected by specifying values for the various keys in the index or by
specifying a value or range of values for one field.
The default format of the extracted data is columns, separated by spaces. The extracted data can be formatted as a comma-separated-value (CSV) file for use in another program, such as a spreadsheet. If the data is to be loaded into another file, it can be formatted so that the Lawson dbload command can accept the extracted records. You can also choose whether to include the field headers in the output.
Unless you use the -d or -c option, the utility truncates fields larger than 80 columns.
Options
| Option |
Description |
| c |
Put the output in a comma-separated value format. You can also use this option to dump files containing fields larger than 80 columns. |
| n |
Dump output without the field headers. |
| d |
Dump to flat file. Creates a file that the dbload utility can import. You can also use this option to dump files containing fields larger than 80 columns. |
| t |
Terse mode. Does not show record count. If you use this option, specify one or more field names in the field Name (s) fields. |
| iindex |
Dumps the database using the index you specify instead of the primary index of the file (for example -GLMSET2). |
| dataarea|dataid |
Data area or data ID (i.e., productline) containing the database file you want to dump. |
filename |
File you want to dump. |
| -f FieldName(s) |
Names of up to 250 fields (the limit on a file record) you want to dump data for. |
| -k rangekey(s) |
Values for each key in the index for the file you want to dump data from. Specify a value for up to 13 keys, each separated by a space. If the value has spaces in it, enclose that value in apostrophes or insert a hyphen where the space or spaces would be. |
| -v fieldvalue |
Dumps data for specified field. If this does not work for you, download the latest rngdbdump binary object from the Lawson support web site.
Syntax for a range dump is something like:
rngdbdump -c productline filename -v field=BEGVAL:ENDVAL
|
|