Specific methods for generating and executing SQL statements

Execute option for UNDO SQL statements

When you generate UNDO SQL statements, you can direct Log Master to execute the statements after it writes them. The product includes the SQL execution as part of a log scan step within the work ID.

For more information, see:

• Example 1: Backing out transactions with UNDO

• Section about syntax in the Command and syntax reference

Execute option for UNDO DDL statements

When you generate UNDO DDL statements, you can direct Log Master to execute the statements after it writes them. The product includes the DDL execution as part of a log scan step within the work ID.

For more information, see:

• Defining an output DDL file

• Section about syntax in the LOGSCAN DDL file definition

Automated Drop Recovery (Re-create DDL statements)

You can direct Log Master to execute DDL statements that re-create the dropped objects. The product includes the DDL execution as part of an automated drop recovery step within the work ID. The product also provides a separate EXECSQL step for the post-recovery SQL statements that it generates to recover a dropped table.

For more information, see:

• Generating drop recovery output

• Section about syntax in the DROPRECOVERY statement