outputPureQueryXml property

Specifies a fully-qualified or relative path to and name of the file or files that the process of capturing SQL statements creates.

The format of the value that you set for this property is name.extension or name$X.extension.

name
Specifies the name of the file. Include the absolute or relative path to the file.
$X
Use this suffix if you are creating multiple pureQueryXML files for a clustered application. pureQuery replaces these characters with two values: the ID of the ClassLoader object for the application, and a timestamp that indicates when pureQuery created the given file.
.extension
The extension must be either .pdqxml or .xml.

When you are capturing SQL statements for the first time from a non-clustered application to a file: You can use the outputPureQueryXml property or the pureQueryXml property to capture SQL statements to a file. You must use one of them, however. The directory that you specify must exist. You must have permission to create files in that directory. If you specify both properties, the outputPureQueryXml property takes precedence.

When you are capturing SQL statements for the first time from a clustered application to files: Use the outputPureQueryXml property with the $X suffix.

When you are capturing additional SQL statements from a non-clustered application for which you already created a pureQueryXML file: You can use the pureQueryXml property to specify the file as an input file and use the outputPureQueryXml property for capturing additional SQL statements that do not already appear in the input file.

When you are capturing additional SQL statements from a clustered application to files: Use the pureQueryXml property to specify as an input file the pureQueryXML file that is the result of the merge of the files that you created when you last captured SQL statements from the application. Use the outputPureQueryXml property with the $X suffix to specify the files that you want to capture additional SQL statements to.

You cannot use this property when you want an application to run only statements that were previously captured. You must use the pureQueryXml property to specify the file in which those statements are captured.

Important: If captured SQL is being saved to the files located on file system, you must ensure that the application is quiesced and that the files are not being written to when you retrieve the files. If the application is not is quiesced, the contents of the files might not be valid or the application might not be able to update the files causing an I/O error. You can use the -validateXml option with the Merge utility or the Configure utility to ensure the validity of the file.

If both the outputPureQueryXml and outputXmlRepository properties are set, then an exception is thrown.

To capture SQL statements into a repository that is created in a database, you can specify the outputXmlRepository property or the finalRepositoryProperties property.


Feedback