IBM Books

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 83. 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 | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]