UNCATALOG ODBC DATA SOURCE command

The UNCATALOG ODBC DATA SOURCE command deletes a user or system ODBC data source.

A data source, in ODBC (Open Database Connectivity) terminology, is a user-defined name for a specific database. That name is used to access the database through ODBC APIs. On Windows, either user or system data sources can be uncataloged. A user data source is only visible to the user who cataloged it, whereas a system data source is visible to and can be used by all other users.

This command is available on Windows only.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramUNCATALOGUSERSYSTEMODBC DATA SOURCEdata-source-name

Command parameters

USER
Uncatalog a user data source. This is the default if no keyword is specified.
SYSTEM
Uncatalog a system data source.
ODBC DATA SOURCE data-source-name
Specifies the name of the data source to be uncataloged. Maximum length is 32 characters.

Usage notes

On Microsoft Windows operating systems, you must execute the UNCATALOG SYSTEM ODBC DATA SOURCE command from a Db2® command window running with full administrator privileges.