The Configure utility option -setPreStatusOfAllPkgs affects the value of the configureStatus attribute. If the option is specified, the Configure utility process the SQL statements and statement sets after the effect of the option is taken into account. The processing is not the based on the value of the configureStatus attribute at the start of the Configure operation.
You run the StaticBinder utility specifying the pureQueryXML file to bind or rebind the SQL statements in the statement sets. You can specify the StaticBinder option -differenceOnly TRUE when performing a bind operation. The option limits the bind operation to only the statements in statement sets that need to be rebound.
The following table lists the Configure utility options that change named statement sets if the value of the -cleanConfigure option is FALSE or is not specified. If you run the Configure utility with the value of the -cleanConfigure option set to TRUE, all statement sets are modified. All Configure utility options apply to all SQL statements that are in unnamed statement sets.
Option | Named statement sets that are changed |
---|---|
-allowStaticRowsetCursors | Statement sets with the value of the configureStatus attribute set to REQUIRED. |
-collection | Statement sets with the value of the configureStatus attribute set to REQUIRED. |
-forceSingleBindIsolation | Statement sets with the value of the configureStatus attribute set to REQUIRED. |
-groupSQLBySpecialRegisters | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-groupSQLByStrings | Named statement sets are not changed. Only unnamed statement sets are changed. |
-markDDLForBind | Statement sets with the value of the configureStatus attribute set to REQUIRED. |
-maxMissingSections | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-pkgVersion | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-removeSQLInactiveForDays | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-removeInvalidSQL | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-replaceLocations | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-replaceSchemas | Statement sets with the value of the configureStatus attribute set to REQUIRED or AUTO. |
-restoreInvalidSQLForce | All named statement sets. |
-rootPkgName | Named statement sets are not changed. Only unnamed statement sets are changed. |
-setPostStatusOfAllPkgs | All named statement sets. |
-setPreStatusOfAllPkgs | All named statement sets. |
-sqlLimit | Named statement sets are not changed. Only unnamed statement sets are changed. |
There are Configure utility operations that are not associated with an option. The operations maintain the pureQueryXML file and ensure its validity.
Except for named statements sets with the value of the configureStatus attribute is FINAL, any of the following changes might occur. The changes require that the impacted packages be rebound.