SQL Reference

SYSCAT.SERVERS

Each row represents a data source. Catalog entries are not necessary for tables that are stored in the same instance that contains this catalog table.


Table 87. Columns in SYSCAT.SERVERS Catalog View
Name Data Type Nullable Description
WRAPNAME VARCHAR(128)
Wrapper name.
SERVERNAME VARCHAR(128)
Name of data source as it is known to the system.
SERVERTYPE VARCHAR(30) Yes Type of data source (always uppercase).
SERVERVERSION VARCHAR(18) Yes Version of data source.
REMARKS VARCHAR(254) Yes User supplied comments, or null.


[ Top of Page | Previous Page | Next Page ]