Show TOC

db_datasource_listLocate this document in the navigation structure

Use

This command is only available if you have a bridge scenario.

You can use it to display all data sources that were added to the database you are currently logged on to and their properties.

Prerequisites

You have the server permission ParamFull

Structure

db_datasource_list

Result

OK

Name: <ds_name>

Id: <ds_id>

ExecType: <ex_type>

Type: <ds_type>

File: <ds_file>

HostName: <ds_hostname>

DatabaseName: <ds_databasename>

UserName: <ds_username>

Password: <ds_password>

Value

Description

<ds_name>

Name of the data source

<ds_id>

Surrogate key of the data source

<ex_type>

Mode in which the data source is made available to the current database

Possible values are: INPROC | LOCAL

INPROC: The command runs in the kernel process of the database

LOCAL: The command runs in a special process outside the database on the local database computer

<ds_type>

Type of the data source

Possible values are: MAXDB | TERADATA | NEOVIEW

<ds_computer_name>

Computer name of the data source

<ds_database_name>

Database name of the data source

<ds_user_name>

User name for authentication with the database of the data source

<ds_password>

Password for authentication with the database of the data source, displayed as ****

In the event of errors, see Reply Format.