pureQueryXmlRepository property

Specifies the repository that contains the pureQueryXML file data that is used with a CLI or .NET application enabled with pureQuery client optimization. The application retrieves the pureQueryXML file data from a repository that was created in a database.

This keyword is supported only for CLI or .NET applications enabled with pureQuery client optimization. There is no default value for the keyword. The keyword and values are both case-independent. A runtime group created in the repository must also be specified with the propertiesGroupId keyword.

Only the pureQueryXML file data is retrieved from the repository. The pureQuery Runtime settings are not retrieved from the repository. The pureQuery Runtime settings specified in the connection are used.

If the pureQueryXmlRepository property is specified the following keywords cannot be specified:
  • The pureQueryXml keyword
  • The value of captureMode keyword cannot be ON
Note: If the repository is created with a non-default schema name by specifying the manageRepository option -repositorySchema, it cannot be accessed by CLI or .NET applications enabled with pureQuery client optimization.

CLI00202E is returned when retrieving the pureQueryXml capture file from the repository fails.

The following values are valid for pureQueryXmlRepository:
ds://dsn_name
Specifies a DSN name. A CLI or .NET application connects to the specified database using the DSN details from the db2dsdriver.cfg or db2cli.ini configuration files. The database must contain a repository. The user connecting to the repository must have read access to the repository. The pureQueryXML file data is retrieved from the repository and used by the application.

The following are examples of a dsn connection string:

ds://sample_dsn
connection_string
Specifies a database using a CLI or .NET connection string. The database must contain a repository. The database user connecting to the repository must have read access to the repository. The pureQueryXML data are retrieved from the repository and used by the CLI or .NET application.

The runtime group ID must also be specified using the propertiesGroupId keyword.

The following example URL specifies the SAMPLE database:
DATABASE='SAMPLE;PORT=50001;HOSTNAME=server1.test.com;UID=user1;PWD=passwrd1'

DB2 CLI and IBM Data Server Driver usage notes

When using DB2® Call Level Interface (CLI) or the IBM® Data Server Driver with pureQuery Runtime, you can use the pureQuery Runtime property as a configuration keyword.

IBM CLI keyword syntax
pureQueryXmlRepository = 'ds://dsn_name|connection_string'
IBM Data Server Driver configuration syntax
<parameter name="pureQueryXmlRepository" value="ds://dsn_name|connection_string" />
Equivalent IBM Data Server Provider for .NET connection string keyword
pureQueryXmlRepository=ds://dsn_name|connection_string

Feedback