SQL batch execution program

The CHECK PLUS for DB2 product provides an SQL batch execution program (ACKESQL) that you can use to execute the DELETE statements in the discard data set (SYSDISC) that CHECK PLUS creates in the SQLDEL or SPUFI format. For details about specifying the format of the discard data set, see the DISCARDFMT option.

Important

We recommend that you specify DISCARDFMT SQLDEL if you plan to use the ACKESQL program.

Related topics

Command-and-syntax-reference

Examples-of-CHECK-PLUS-jobs

CHECK-command-syntax

DISCARDFMT

Although you can use a different SQL execution program to execute the DELETE statements, the ACKESQL program offers to commit, restart, lock, and CHKP reset capabilities through its execution parameters. Also, ACKESQL provides detailed messages that report the program’s activity. This assumes that you are using ACKESQL to execute the DELETE statements.

You run ACKESQL separately from CHECK PLUS by using JCL. Deleting rows with RI violations outside of the checking process enables the table space to remain available during the delete process. For more information about ACKESQL, see Using-ACKESQL.

However, you can choose to restrict access to the data during the delete process by establishing certain options as described in the following topic:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*