Configuring Connection Properties with ODBC

When working with ODBC connection, the user can set the connection properties Driver Connection#URL Connection Properties that are available in Teiid by executing the command like below.

SET <property-name> TO <property-value>

for example to turn on the result set caching you can issue

SET resultSetCacheMode TO 'true'

Another option is to set this as VDB property in the vdb file as

CREATE DATABASE vdb OPTIONS ("connection.partialResultsMode" true);

Or in an XML VDB:

<vdb name="...">
    <property name="connection.resultSetCacheMode" value="true"/>

results matching ""

    No results matching ""