MATVIEW=string

ODBC

VIEW

By default, when you run the ODBC function SQLTables, the value VIEW is returned in the TABLE_TYPE column for materialized views. Use the MatView connection parameter to specify a different return value. The string that you specify is also returned when the SQLTables function is called with a TableType filter.

• ODBC support

To have the SQLTables() function return materialized views as type MATERIALIZED VIEW, connect as follows:

UID=DBA;PWD=sql;ServerName=server-name;MATVIEW=MATERIALIZED VIEW