VMS Help  —  RMU72  Extract  Command Qualifiers, Defaults
    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.
Close Help