Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Dumping and Loading : Dumping database contents : Dumping selective contents with PROUTIL
 
Dumping selective contents with PROUTIL
A selective binary dump allows you to specify that only records matching your criteria are dumped.
Use the following syntax to perform a selective binary dump within a bracketed range:
proutil db-name -C dumpspecified [owner-name.]table-name.field-name
   operator1 low-value AND operator2 high-value directory
[-preferidx index-name]
The table below describes selective dump syntax.
Table 52. DUMPSPECIFIED syntax
Field
Description
db-name
Specifies the database from which you want to dump.
owner-name
Specifies the owner of the table containing the data you want to dump.
table-name
Specifies the name of the table containing the data you want to dump.
field-name
Specifies the index you are using to select the records to dump.
operator1 and operator2
Specifies the comparison to make when selecting records. Operator can be one of five values:
*EQ —Equal to
*GT — Greater than
*GE — Greater than or equal to
*LT — Less than
*LE — Less than or equal to
Note: The first value and operator, combined with the second value and operator, define a subset. You can not use AND to dump two sets of non-contiguous results.
low-value and high-value
Specifies the range of values against which the field contents will be compared.
AND
Specifies a bracketed range for the binary dump.
directory
Specifies the name of the target directory where the data will be written.
-preferidx index-name
By default, DUMPSPECIFIED uses the primary index to sort rows; specifying an index with -preferidx orders the rows by index-name.
Note: For databases enabled for table partitioning or multi-tenancy, you can further refine your dump by partition, tenant, or group. For details on the complete syntax, see PROUTILDUMPSPECIFIED qualifier.

Examples

The following syntax dumps all order date values greater than 2/3/02 from the Sports2000 database:
proutil sports2000 -C dumpspecified order.order_date GT '02-03-2002'
The following syntax dumps all item prices less than $25.90 from the Sports2000 database:
proutil sports2000 -C dumpspecified item.price LT 25.9
The following syntax dumps all order ship dates of 12/24/01 from the Sports2000 database into the /dev/results directory:
proutil sports2000 -C dumpspecified order.ship_date EQ '12-24-2001' /dev/results
The following syntax dumps all back ordered items from the Sports2000 database into the /inventory/warehouse1 directory:
proutil sports2000 -C dumpspecified order_line.backorder EQ yes /inventory/warehouse1