SET <property-name> TO <property-value>
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.
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"/> ... </vdb>