Format=options
If the Format qualifier is not specified, Oracle RMU outputs data
to a fixed-length binary flat file.
The format options are:
o Format=Binary
If you specify the Format=Binary option, Oracle RMU does not
perform any data conversion; data is output in a flat file
format with all data in the original binary state.
Output Fields describes the output fields and data types of an
output record in Binary format.
Table 19 Output Fields
Byte
Field Name Data Type LengthDescription
ACTION CHAR (1) 1 Indicates record state.
"M" indicates an insert or
modify action. "D" indicates a
delete action. "E" indicates
stream end-of-file (EOF)
when a callback routine is
being used. "P" indicates
a value from the command
line Parameter qualifier
when a callback routine is
being used (see Parameter
qualifier). "C" indicates
transaction commit information
when the Include=Action=Commit
qualifier is specified.
RELATION_ CHAR (31) 31 Table name. Space padded to 31
NAME characters.
RECORD_TYPE INTEGER 4 The Oracle Rdb internal
(Longword) relation identifier.
DATA_LEN SMALLINT 2 Length, in bytes, of the data
(Word) record content.
NBV_LEN SMALLINT 2 Length, in bits, of the null
(Word) bit vector content.
DBK BIGINT 8 Records logical database key.
(Quadword) The database key is a 3-field
structure containing a 16-
bit line number, a 32-bit
page number and a 16-bit area
number.
START_TAD DATE VMS 8 Date/time of the start of the
(Quadword) transaction.
COMMIT_TAD DATE VMS 8 Date/time of the commitment of
(Quadword) the transaction.
TSN BIGINT 8 Transaction sequence number of
(Quadword) the transaction that performed
the record operation.
RECORD_ SMALLINT 2 Record version.
VERSION (Word)
Record Data Varies Actual data record field
contents.
Record NBV BIT VECTOR Null bit vector. There is
(array of one bit for each field in the
bits) data record. If a bit value
is 1, the corresponding field
is NULL; if a bit value is
0, the corresponding field
is not NULL and contains an
actual data value. The null
bit vector begins on a byte
boundary. Any extra bits in
the final byte of the vector
after the final null bit are
unused.
o Format=Dump
If you specify the Format=Dump option, Oracle RMU produces an
output format suitable for viewing. Each line of Dump format
output contains the column name (including LogMiner prefix
columns) and up to 200 bytes of the column data. Unprintable
characters are replaced with periods (.), and numbers and
dates are converted to text. NULL columns are indicated
with the string "NULL". This format is intended to assist
in debugging; the actual output contents and formatting will
change in the future.
o Format=Text
If you specify the Format=Text option, Oracle RMU converts
all data to printable text in fixed-length columns before
unloading it. VARCHAR(n) strings are padded with blanks when
the specified string has fewer characters than n so that the
resulting string is n characters long.
o Format=(Delimited_Text [,delimiter-options])
If you specify the Format=Delimited_Text option, Oracle RMU
applies delimiters to all data before unloading it.
DATE VMS dates are output in the collatable time format, which
is yyyymmddhhmmsscc. For example, March 20, 1993 is output as:
1993032000000000.
Delimiter options are:
- Prefix=string
Specifies a prefix string that begins any column value in
the ASCII output file. If you omit this option, the column
prefix is a quotation mark (").
- Separator=string
Specifies a string that separates column values of a row.
If you omit this option, the column separator is a single
comma (,).
- Suffix=string
Specifies a suffix string that ends any column value in
the ASCII output file. If you omit this option, the column
suffix is a quotation mark (").
- Terminator=string
Specifies the row terminator that completes all the column
values corresponding to a row. If you omit this option, the
row terminator is the end of the line.
- Null=string
Specifies a string that, when found in the database column,
is unloaded as "NULL" in the output file.
The Null option can be specified on the command line as any
one of the following:
* A quoted string
* An empty set of double quotes ("")
* No string
The string that represents the null character must be
quoted on the Oracle RMU command line. You cannot specify a
blank space or spaces as the null character. You cannot use
the same character for the Null value and other Delimited_
Text options.
NOTE
The values for each of the strings specified in the
delimiter options must be enclosed within quotation
marks. Oracle RMU strips these quotation marks while
interpreting the values. If you want to specify a
quotation mark (") as a delimiter, specify a string
of four quotation marks. Oracle RMU interprets four
quotation marks as your request to use one quotation
mark as a delimiter. For example, Suffix = """".
Oracle RMU reads these quotation marks as follows:
o The first quotation mark is stripped from the string.
o The second and third quotation mark are interpreted
as your request for one quotation mark (") as a
delimiter.
o The fourth quotation mark is stripped.
This results in one quotation mark being used as a
delimiter.
Furthermore, if you want to specify a quotation mark as
part of the delimited string, you must use two quotation
marks for each quotation mark that you want to appear in
the string. For example, Suffix = "**""**" causes Oracle
RMU to use a delimiter of **"**.