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.
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.
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 |
OK
In the event of errors, see Reply Format.