Update the documentation of the ODBC with connection properties ---------------------------------------------------------------- Key: TEIID-4179 URL: https://issues.jboss.org/browse/TEIID-4179 Project: Teiid Issue Type: Task Components: Documentation Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 9.0 ConnSettings =SET resultSetCacheMode TO 'true' That will set the connection property. Please this applies any connection property. If there are multiple, you delimit them by ; Similarly in Windows DSN wizard too. In the vdb.xml, you can add a vdb level property like <vdb name="..."> <property name="connection.resultSetCacheMode" value="true"/> ... </vdb>