Specifies the repository that contains
the pureQueryXML file data that is used with a CLI 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 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
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 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 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 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
- N/A