SQLType

Attributes

This parameter has the following attributes:

Usage

Logical log input that conforms to the published format includes a field named SQLTYPE in the header of each record in the logical log data file. The SQLType parameter causes High-speed Apply Engine to select a different set of records based on the value in this field. High-speed Apply Engine generates SQL statements from the records it selects. For more information about logical log data records, see Logical log files.

Specify one of the following values for the SQLType parameter:

• Specify Redo to cause High-speed Apply Engine to generate SQL statements from redo records in the logical log input (where the SQLTYPE field is 'R'). A logical log input file does not contain any redo records unless a REDO recovery point was specified when the logical log was generated.
• Specify Undo to cause High-speed Apply Engine to generate SQL statements from undo records in the logical log input (where the SQLTYPE field is 'U'). If this parameter is UNDO, High-speed Apply Engine:
  • Reverses the statement type of the original data changes (for example, if the original statement was an INSERT, High-speed Apply Engine generates and executes a DELETE statement)
  • Reverses the order of the original data changes. (To accomplish this, High-speed Apply Engine must sort the logical log input. When SQLType is UNDO, High-speed Apply Engine sets the value of the Sort parameter to Yes, regardless of the value in your configuration. For more information, see Sort.)
• Specify Migrate to cause High-speed Apply Engine to generate SQL statements from undo records in the logical log input (where the SQLTYPE field is 'U'). If this parameter is Migrate, High-speed Apply Engine does not reverse the statement type or the order of the original data changes.

For more information about these values, see Command and syntax reference.

The value of this parameter affects the default value of the IncludeRI parameter (for more information, see IncludeRI).