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 1. 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.
Note: For compound indexes, the specified field must be the leading component of the compound index.
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 PROUTIL DUMPSPECIFIED 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