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 vdb.xml file as
<vdb name="..."> <property name="connection.resultSetCacheMode" value="true"/> ... </vdb>