RetCatalogAsCurrServer CLI/ODBC and IBM data server driver configuration keyword
Specifies whether catalog functions return the CURRENT SERVER value or a null value for the catalog columns.
- db2cli.ini keyword syntax:
- RetCatalogAsCurrServer= 0 | 1
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name=“RetCatalogAsCurrServer” value="0 | 1”/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- If the target DBMS returns null for the catalog columns, the CURRENT SERVER value will not be substituted.
- Usage notes:
- If the catalog functions for the target DBMS return a null value for the catalog columns,
setting RetCatalogAsCurrServer to 1 causes the DBMS to return the CURRENT SERVER value instead.
- 0 = Catalog functions return the null value for the catalog columns (default).
- 1 = Catalog functions return the CURRENT SERVER value, instead of the null value, for the catalog columns.
For example, assume the catalog function
SQLTables()returns a result set where the values in the TABLE_CAT column are null values. Setting RetCatalogAsCurrServer to 1 causes the DBMS to return the CURRENT SERVER value in the TABLE_CAT column.