Defaults[=defaults-list]
This qualifier is used to change the output of the RMU Extract
command. The following defaults can be modified with the Defaults
qualifier:
o Allocation=integer
Noallocation
When you create a test database using the script generated
by the RMU Extract command, the allocation from the source
database may not be appropriate. You can use the Allocation
keyword to specify an alternate value to be used by all
storage areas, or you can use the Noallocation keyword to
omit the clause from the CREATE STORAGE MAP syntax. The
default behavior, when neither keyword is used, is to use
the allocation recorded in the database for each storage area.
See also the Snapshot_Allocation keyword.
o Date_Format
Nodate_Format
By default, the RMU Extract process assumes that DATE types
are SQL standard-compliant (that is DATE ANSI) and that the
built-in function CURRENT_TIMESTAMP returns TIMESTAMP(2)
values. If your environment uses DATE VMS exclusively, then
you can modify the default by specifying the default DATE_
FORMAT=VMS. The legal values are described in the Oracle Rdb
SQL Reference Manual in the SET DEFAULT DATE FORMAT section.
The default is Date_Format=SQL92.
Use Nodate_Format to omit the setting of this session
attribute from the script.
o Dialect
Nodialect
For some extracted SQL scripts the language dialect must
be specified. You can use the Dialect keyword to supply a
specified dialect for the script. You can find the legal
values for this option in the Oracle Rdb SQL Reference Manual
in the SET DIALECT section. The default is Nodialect.
o Language
Nolanguage
The RMU Extract commmand uses the process language, that is,
the translated value of SYS$LANGUAGE, or ENGLISH, for the
SET LANGUAGE command. However, if the script is used on a
different system then this language might not be appropriate.
You can use the Language keyword to supply a specified
language for the script. Legal language names are defined by
the OpenVMS system logical name table; examine the logical
name SYS$LANGUAGES for a current set. Use the Nolanguage
keyword to omit this command from the script.
o Quoting_Rules
Noquoting_Rules
You can use the Quoting_Rules keyword to supply a specified
setting for the script. You can find the legal values for
this option in the Oracle Rdb SQL Reference Manual in the SET
QUOTING RULES section. The default is Quoting_Rules=SQL92.
The RMU Extract command assumes that SQL keywords and names
containing non-ASCII character set values are enclosed in
quotation marks.
o Snapshot_Allocation=integer
Nosnapshot_Allocation
When you create a test database from the RMU Extract output,
the snapshot file allocation from the source database may not
be appropriate. You can use the Snapshot_Allocation keyword to
specify an alternate value to be used by all snapshot areas,
or you can use the Noallocation keyword to omit the "snapshot
allocation is" clause. The default behavior, when neither
keyword is used, is to use the snapshot allocation stored in
the database for each snapshot area. See also the Allocation
keyword.