Kbase P57006: How to use dumpspecified?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/8/2010 |
|
Status: Verified
GOAL:
How to use dumpspecified?
GOAL:
How to binary dump fields meeting certain criteria ?
GOAL:
What Progress utility should I use to archive large amounts of data ?
GOAL:
How can I archive data?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1D
OpenEdge 10.x
FIX:
An enhancement was made to the binary dump utility to selectively dump portions of a table based on a field's value in order to facilitate the archiving of large amounts of data. This feature was implemented in 9.1D and patched in 9.1D06.
To date there are still some documentation enhancements needed and this solution hopes to address these in the interim.
Syntax:
proutil "dbname" -C dumpspecified "[owner.]table.index_field" "operator" "value" "directory"
Notes:
o Decimal field values are not supported.
o Character values are case-sensitive.
o Progress 9.1D06 addressed an issue with dumpspecified character values not being dumped.
o If a field needs to be compared to a string containing other than alpha characters (including spaces or numbers), then the string must be surrounded by double quotes:
"Progress Solution", "13-02-2003", "1065 La Avenida Ave ".
o For performance reasons, the "[owner.]table.index_field" must be an indexed field and the first component of the index. Should a dump by an un-indexed field be needed, then either add an index to this field and build the indexes on that field first, or else the primary index will be used by default. When the primary index is used on an un-indexed field, the dumpspecified results may not be what you expected.
Examples: (from a copy of the sports2000 database)
a specific customer:
proutil dbname -C dumpspecified customer.name EQ "Lift Line Skiing"
To specify a negative integer value using the Dumpspecified qualifier, the number must be escaped and enclosed in single quotes, as in the following:.
All item numbers higher than -90:
proutil dbname -C dumpspecified PUB.Item.ItemNum GT '\-90'
Dates must have the format MM-DD-YYYY which was a Y2k addition, as in the following:.
All invoices on or after February 13th, 1995:
proutil dbname -C dumpspecified invoice.invoicedate GE "02-13-1995"