Difference between revisions of "SET GATEWAY"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (5 intermediate revisions by 2 users 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 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[CONNECTED()]], [[GATEWAY()]], [[LOGIN]] |
| Line 26: | Line 19: | ||
If <expC1> is not included with the SET GATEWAY command, the connection in that workarea will be detached. | 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. | 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: 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: 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: | 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: | ||
| Line 42: | Line 38: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set gateway to "ora@sales:scott/tiger" | set gateway to "ora@sales:scott/tiger" | ||
// short format for local ODBC data source | // short format for local ODBC data source | ||
| − | set gateway to "odbc:Northwind"</ | + | set gateway to "odbc:Northwind"</code> |
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|GATEWAY]] | [[Category:Set_Commands|GATEWAY]] | ||
| + | [[Category:SQL]] | ||
| + | [[Category:SQL Set Commands]] | ||
| + | [[Category:Remote Data Connectivity]] | ||
| + | [[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
