Show TOC

db_datasource_addLocate this document in the navigation structure

Use

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

You can use it to add a data source to the database you are currently logged on to. The database of the data source to be added is online.

Prerequisites
  • You have created the user SAP in the database you are currently logged on to (see: user_sap).

  • You have the server permission ParamFull or AccessUtility.

Structure

db_datasource_add Name <ds_name> Type <ds_type> ExecType <ex_type> [HostName <ds_computer_name>] DatabaseName <ds_database_name> UserName <ds_user_name> Password <ds_password> Options [<option_list>]

<option_list> :: = <option_spec> | <option_spec> <option_spec>

<option_spec> ::= <option> <value>

Option

Description

<ds_name>

Name of the data source

If a data source of the same name was already added, the command fails.

<ds_type>

Type of the data source

Possible values are: MAXDB | TERADATA | NEOVIEW

<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_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

Result

OK

In the event of errors, see Reply Format.