SYSCAT.TABOPTIONS catalog view

Each row represents an option that is associated with a remote table.

Table 1. SYSCAT.TABOPTIONS Catalog View
Column Name Data Type Nullable Description
TABSCHEMA VARCHAR (128)   Schema name of a table, view, alias, or nickname.
TABNAME VARCHAR (128)   Unqualified name of a table, view, alias, or nickname.
OPTION VARCHAR (128)   Name of the table option.
SETTING CLOB (32K)   Value of the table option.