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