Kbase P102951: Can more than one parameter be specified when using the dumpspecified option of proutil?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/19/2009 |
|
Status: Verified
GOAL:
Can more than one parameter be specified when using the dumpspecified option of proutil?
GOAL:
How to specify a range with dumpspecified?
GOAL:
When was dumpspecified modified to allow range selection?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1B03 32-bit Service Pack
FIX:
The binary dumpspecified function, beginning in 10.1B03, now allows the user to specify a bracketed range for the binary dump.
The new functionality defines the AND operator and uses the first value and operator pair along with the second value and operator pair to define an enclosed subset.
You must define an enclosed subset of contiguous results.
The AND operator does not allow a dump of two sets of non-contiguous results (for example: custnum LE 30 AND custnum GE 50 is not allowed. This construction would give all records before custnum=30 and after custnum=50 which is essentially a NOT BETWEEN).
Syntax:
proutil db-name -C dumpspecified [owner-name.] table-name.field-name operator
field-value1 AND operator value2 directory [-preferidx indexname]
where operator1 is either GT or GE and operator2 is either LE or LT.
Current Limitations to the dumpspecified functionality:
1) If dumping data for a column with datatype BIGINT, an overflow condition occurs when the specified column value is larger than the max BIGINT value. No error message is generated, and the dump continues as if the number specified is a negative number.
2) Negative integers are not supported by specified binary dump input parameters. You can dump all negative values by specifying a value range as "LT 0" for the column, but specifying any negative integer, such as "LT -1", fails. The specified binary dump utility cannot interpret command lines with a "-" negative sign in the input parameter on command line.