Difference between revisions of "SET GATEWAY"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Establish a gateway to a Recital Database Gateway | Establish a gateway to a Recital Database Gateway | ||
| Line 49: | Line 45: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| Line 55: | Line 51: | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:SQL Set Commands]] | [[Category:SQL Set Commands]] | ||
| − | [[Category:Data Connectivity]] | + | [[Category:Remote Data Connectivity]] |
| − | [[Category:Data Connectivity Set Commands]] | + | [[Category:Remote Data Connectivity Set Commands]] |
Latest revision as of 11:52, 22 June 2010
Purpose
Establish a gateway to a Recital Database Gateway
Syntax
SET GATEWAY TO [<expC1>] [IN <workarea/alias>] [ALIAS <expC2>]
See Also
Description
The SET GATEWAY command is used to establish a connection to a Recital Database Gateway via the Recital Database Server. Each workarea can have a separate gateway established.
<expC1> is a character string that must be formatted in the following way:
servername@machinename:username/password-database.protocol
If <expC1> is not included with the SET GATEWAY command, the connection in that workarea will be detached.
An optional ALIAS <expC2> keyword can be used to specify an alias name for the workarea that is currently connected.
NOTE: For local ODBC data sources, a short format of <expC1> can be used, specifying only the data source name as configured in the ODBC Data Source Administrator.
NOTE: If the protocol is not specified, TCP/IP is assumed.
NOTE: The database entry when connecting to Oracle is not required. This entry can be used to pass hostname information when SQL*NET is being used. The information required differs depending on the version of SQL*NET:
SQL*NET 1
database = T:<node>:<SID>
SQL*NET 2
database = <service name>
Example
set gateway to "ora@sales:scott/tiger" // short format for local ODBC data source set gateway to "odbc:Northwind"
Products
Recital Server, Recital
