DB2 10.5 for Linux, UNIX, and Windows

UNCATALOG ODBC DATA SOURCE command

Uncatalogs 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


              .-USER---.                                       
>>-UNCATALOG--+--------+--ODBC DATA SOURCE--data-source-name---><
              '-SYSTEM-'

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.