Merging subsets of statement sets that are in pureQueryXML files

By deleting the names of two or more statement sets in a pureQueryXML file, you can cause the Configure utility to merge those statement sets into a number of sets that is determined by the value of the Configure option sqlLimit.

About this task

A statement set within a pureQueryXML file is a set of statements that form the basis of one or four DB2® packages, depending on whether you want a package for one isolation level or one package for each of the four isolation levels.

If the number of SQL statements in the statement set that results from the merge operation exceeds the value of the option sqlLimit, the Configure utility creates another statement set for the excess statements. If this set also has more statements than the value of sqlLimit, the Configure utility creates another set. This process continues until the number of remaining statements is less than the value of sqlLimit.

If you want to merge together all of the statement sets that are in a pureQueryXML file, not a subset of them, use the -cleanConfigure option of the Configure utility. Set this option to TRUE.

Procedure

To merge together a subset of statement sets that are in a pureQueryXML file:

  1. Open the pureQueryXML file in a text editor.
    Recommendation: IBM® strongly recommends that you edit pureQueryXML files by using the workbench only. If you edit a pureQueryXML file outside of the workbench, you risk making the file unusable.

    If you must edit a pureQueryXML file outside of the workbench, in the <statementSet> tag of the statement set in which an edit occurs set the value of the configureStatus attribute to REQUIRED, like this: configureStatus="REQUIRED" Then, run the Configure utility on the file.

  2. Find the opening <statementSet> tag for one of the statement sets that you want to merge together.
  3. In the opening <package> tag after the <statementSet> tag, find the name attribute.
  4. Delete the value of the name attribute, leaving an empty string: name=""
  5. Repeat steps 2 through 4 for each statement set that you want to merge together.
  6. Save and close the file.
  7. Run the Configure utility on the file.
  8. Open the file to verify the resulting statement sets.

Feedback