DB2 Version 9.7 for Linux, UNIX, and Windows

RetCatalogAsCurrServer CLI/ODBC 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

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.