Record_Definition=[File=name,options]
Record_Definition=[Path=name,options]
Record_Definition=Nofile
Creates an RMS file containing the record structure definition
for the output file. The record description uses the CDO record
and field definition format. The default file extension is .rrd.
If you omit the File=name or Path=name option you must specify an
option.
The date-time syntax in .rrd files generated by this qualifier
changed in Oracle Rdb V6.0 to make the .rrd file compatible with
the date-time syntax support for Oracle CDD/Repository V6.1. The
RMU Unload command accepts both the date-time syntax generated
by the Record_Definition qualifier in previous versions of Oracle
Rdb and the syntax generated in Oracle Rdb V6.0 and later.
See the help entry for RRD_File_Syntax for more information on
.rrd files and details on the date-time syntax generated by this
qualifier.
The options are:
o Format=(Text)
If you specify the Format=(Text) option, Oracle RMU converts
all data to printable text before unloading it.
o Format=Control
The Format=Control option provides support for SQL*Loader
control files and portable data files. The output file
defaults to type .CTL.
FORMAT=CONTROL implicitly uses a portable data format as TEXT
rather than binary values. The unloaded data files are similar
to that generated by FORMAT=TEXT but includes a NULL vector to
represent NULL values ('1') and non-NULL values ('0').
The SQL*Loader control file uses this NULL vector to set NULL
for the data upon loading.
When FORMAT=CONTROL is used, the output control file and
associated data file are intended to be used with the Oracle
RDBMS SQL*Loader (sqlldr) command to load the data into an
Oracle RDBMS database table. LIST OF BYTE VARYING (SEGMENTED
STRING) columns are not unloaded.
The keywords NULL, PREFIX, SEPARATOR, SUFFIX, and TERMINATOR
only apply to DELIMITED_TEXT format and may not be used in
conjunction with the CONTROL keyword.
DATE VMS data is unloaded including the fractional seconds
precision. However, when mapped to Oracle DATE type in the
control file, the fractional seconds value is ignored. It
is possible to modify the generated control file to use the
TIMESTAMP type and add FF to the date edit mask.
NOTE
The RMU Load command does not support loading data using
FORMAT=Control.
o Format=XML
The Format=XML option causes the output Record_Definition file
type to default to .DTD (Document Type Definition). The output
file defaults to type .XML. The contents of the data file is
in XML format suitable for processing with a Web browser or
XML application.
If you use the Nofile option or do not specify the File or
Path keyword, the DTD is included in the XML output file
(internal DTD). If you specify a name with the File or Path
keyword to identify an output file, the file is referenced as
an external DTD from within the XML file.
The XML file contains a single table that has the name of the
database and multiple rows named <RMU_ROW>. Each row contains
the values for each column in printable text. If a value is
NULL, then the tag <NULL/> is displayed. Example 16 shows this
behavior.
NOTE
The RMU Load command does not support loading data using
FORMAT=XML.
o Format=(Delimited_Text [,delimiter-options])
If you specify the Format=Delimited_Text option, Oracle RMU
applies delimiters to all data before unloading it.
Note that DATE VMS dates are output in the collatable time
format, which is yyyymmddhhmmsscc. For example, March 20, 1993
is output as: 1993032000000000.
If the Format option is not used, Oracle RMU outputs data to
a fixed-length binary flat file. If the Format=Delimited_Text
options is not used, 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.
Delimiter options (and their default values if you do not
specify 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 will be a quotation mark (").
- Separator=string
Specifies a string that separates column values of a row.
If you omit this option, the column separator will be 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 will be 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 will be the end of the line.
- Null=string
Specifies a string, which 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 of 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 **"**.
o Trim=option
If you specify the Trim=option keyword, leading and/or
trailing spaces area removed from each output field. Option
supports three keywords:
o TRAILING - trailing spaces will be trimmed from CHARACTER
and CHARACTER VARYING (VARCHAR) data that is unloaded.
This is the default setting if only the TRIM option is
specified.
o LEADING - leading spaces will be trimmed from CHARACTER and
CHARACTER VARYING (VARCHAR) data that is unloaded.
o BOTH - both leading and trailing spaces will be trimmed.
When the Record_Definition qualifier is used with load or unload
operations, and the Null option to the Delimited_Text option
is not specified, any null values stored in the rows of the
tables being loaded or unloaded are not preserved. Therefore,
if you want to preserve null values stored in tables and you are
moving data within the database or between databases, specify the
Null option with Delimited_Text option of the Record_Definition
qualifier.