Difference between revisions of "SET GATEWAY"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Gateways | Gateways | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[CONNECTED()]], [[GATEWAY()]], [[LOGIN]] |
| Line 26: | Line 23: | ||
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 42: | ||
==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> |
Revision as of 09:55, 16 April 2009
Class
Gateways
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 Database Server, Recital Mirage Server, Recital Terminal Developer
