Difference between revisions of "SET GATEWAY"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET GATEWAY=
 
 
 
==Class==
 
Gateways
 
 
 
 
==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==
LOGIN, GATEWAY(), CONNECTED()
+
[[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==
<pre>
+
<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"</pre>
+
set gateway to "odbc:Northwind"</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[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

CONNECTED(), GATEWAY(), LOGIN


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