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 UNIXWindows 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.
EXAMPLESThe following syntax dumps all order date values greater than 2/3/02 from the Sports2000 database:
The following syntax dumps all item prices less than $25.90 from the Sports2000 database:
The following syntax dumps all order ship dates of 12/24/01 from the Sports2000 database into the /dev/results directory:
The following syntax dumps all back ordered items from the Sports2000 database into the /inventory/warehouse1 directory:
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 |