Difference between revisions of "SET GATEWAY"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
Gateways
 
 
 
 
==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 Database Server, Recital Mirage Server, Recital Terminal Developer
+
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

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