Progress
Database Administration
Guide and Reference


Dumping Field Contents With PROUTIL

Use the following syntax to perform a selective binary dump:

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C dumpspecified [owner-name.]table-name.field-name operator field-value directory

db-name

Specifies the database from which the dump will occur. You must completely define the path.

owner-name

Specifies the owner of the table containing the data you want to dump. You must specify an owner name unless the table’s name is unique within the database, or the table is owned by “PUB.” By default, Progress 4GL tables are owned by PUB.

table-name

Specifies the name of the table containing the data you want to dump.

field-name

Specifies the name of the field containing the data you want to dump.

operator

Specifies the operator to be used: EQ (equals to), GT (greater than), GE (greater than or equal), LT (less than), or LE (less than or equal).

field-value

Specifies the value against which the filed contents will be compared.

directory

Specifies the name of the target directory where the data will be dumped. A directory must be specified.

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 ’2/3/02’ 

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/01’ 
/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 

For more information on selective binary dumps, see the "PROUTIL DUMPSPECIFIED" section of Database Administration Utilities."


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095