Difference between revisions of "SET GATEWAY"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 15: Line 15:
  
 
==See Also==
 
==See Also==
LOGIN, GATEWAY(), CONNECTED()
+
[[LOGIN]], [[CONNECTED()]], [[GATEWAY()]]
  
  
Line 52: Line 52:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[Category:Set_Commands|GATEWAY]]

Revision as of 15:11, 11 March 2009

SET GATEWAY

Class

Gateways


Purpose

Establish a gateway to a Recital Database Gateway


Syntax

SET GATEWAY TO [<expC1>] [IN <workarea/alias>] [ALIAS <expC2>]


See Also

LOGIN, CONNECTED(), GATEWAY()


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