IBM Books

Command Reference

LIST ODBC DATA SOURCES

Lists all available user or system ODBC data sources.

A data source, in ODBC (Open Database Connectivity) terminology, is a user-defined name for a specific database or file system. That name is used to access the database or file system through ODBC APIs. On Windows NT and Windows 95, either user or system data sources can be cataloged. 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 NT, Windows 95, and Windows 3.1 only.

Authorization

None

Required Connection

None

Command Syntax

           .-USER---.
>>-LIST----+--------+--ODBC DATA SOURCES-----------------------><
           '-SYSTEM-'
 

Command Parameters

USER
List only user ODBC data sources. This is the default if no keyword is specified.

SYSTEM
List only system ODBC data sources.

Examples

The following is sample output from the LIST ODBC DATA SOURCES command:



               User ODBC Data Sources
 
Data source name                 Description
-------------------------------- ----------------------------------------
SAMPLE                           IBM DB2 ODBC DRIVER

See Also

CATALOG ODBC DATA SOURCE

UNCATALOG ODBC DATA SOURCE.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]