Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL DUMPSPECIFIED qualifier
 

PROUTIL DUMPSPECIFIED qualifier

Performs a binary dump of selected records.

Syntax

proutil db-name -C dumpspecified [owner-name.]table-name.field-name
operator1 low-value [ AND operator2 high-value]
directory
[ tenant tenant-name| group group-name|
partition partition-name | composite initial]
[-preferidx index-name]
     [ -Cipher 6]

Parameters

db-name
Specifies the database where the data being dumped resides. 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, ABL 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 index field, or the name of a component field of a compound index, to be used to select the data you want to dump. If field-name is an index or the name of a component field of a compound index, it is used to select the data you want to dump, otherwise the primary index is used.
operator1
Specifies the first operator in the range: EQ (equals to), GT (greater than), LT (less than), GE (greater than or equal to), or LE (less than or equal to).
low-value
Specifies the first value against which the field-name value will be compared.
AND
Specifies a bracketed range for the binary dump. The first value and operator, combined with the second value and operator, define a subset. You cannot use AND to dump two sets of non-contiguous result.
operator2
Specifies the second operator in the range: LT (less than), or LE (less than or equal to).
high-value
Specifies the first value against which the field-name value will be compared.
directory
Specifies the name of the target directory where the data will be dumped. You must specify a directory.
tenant tenant-name
Specifies that the DUMPSPECIFIED operation is to be performed only on the table partitions of tenant-name. If tenant-name is not a valid tenant, DUMPSPECIFIED exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.
group group-name
Specifies that the DUMPSPECIFIED operation is to be performed only on the table partitions of group-name. If group-name is not a valid group, DUMPSPECIFIED exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.
partition partition-name
Specifies that the DUMPSPECIFIED operation is to be performed only on the table partition partition-name. If partition-name is not valid, DUMPSPECIFIED exits with an error. Specifying partition is only allowed on databases enabled for table partitioning.
composite initial
Specifies that the DUMP operation is to be performed on the composite initial partition. Specifying composite initial is only allowed on databases enabled for table partitioning.
-preferidx index-name
By default, DUMPSPECIFIED uses the primary index to sort rows. Specifying a different index with -preferidx orders the rows by the specified index.
-Cipher 6
For an Enterprise database enabled for Transparent Data Encryption, specify -Cipher 6 to encrypt the output of the PROUTIL DUMPSPECIFIED with a password-based encryption cipher (PBE). You are prompted to enter the passphrase for the cipher. You must remember this passphrase; you will be prompted to enter the passphrase when loading the binary dump.

Notes

*If a field needs to be compared to a string containing other than alpha characters (including spaces or numbers), single quote the string. For example: ‘John Smith', ‘11-14-2001', or ‘25 Main St'.
*Dumping the data using a character comparison is case-sensitive.
*If specifying a monetary value, do not include the money unit. For example, instead of $5.50, enter 5.5.
*If specifying a negative number, escape the minus sign with a backslash (\). For example: proutil testdb -C dumpspecified "PUB.Item.Item-NUM" LT "\-90".
*Dates must be entered as mm-dd-yyyy.
*The value entered for field-name must be the name of an index field.
*You cannot use DUMPSPECIFIED to dump protected audit data. For more information on auditing and utility security and restrictions, see Auditing impact on database utilities.
*When dumping the contents of a table encrypted with Transparent Data Encryption, the output of the binary dump is not encrypted by default. Encrypt the dump file (container security) by specifying -Cipher 6 and entering a passphrase for the PBE cipher. You will be prompted to enter the passphrase when loading the contents of the dump file.
*When dumping the contents of a multi-tenant database, if no tenant or group is specified, then all the rows meeting the specification are dumped.
*When dumping the contents of a table partitioned table, if no partition is specified, then the entire table is dumped.
*When dumping the contents of a multi-tenant or table-partitioned database, and a tenant, group, partition, or composite initial is specified, the naming convention of the dump file is modified as shown:
table-name_ID{T|G|P|C}_TPGCName.bdn
The elements of the file name are described in Table 97.