Update the documentation of the ODBC with connection properties

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>