A selective binary dump allows you to specify that only the 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 
         [stopaftererror num] [-preferidx index-name]

The following table 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 the following 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 are compared.
AND Specifies a bracketed range for the binary dump.
directory Specifies the name of the target directory where the data is written.
stopaftererror num Stops the utility after the specified number of errors. The default setting, zero, means no stopping. The maximum value is a 32-bit LONG value, 2147483647. In a multi-threaded dump, the stopafterror number aggregates errors from all threads.
-preferidx index-name Orders the rows by index-name. By default, DUMPSPECIFIED uses the primary index to sort rows.
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