SET GATEWAY

From Recital Documentation Wiki
Revision as of 15:07, 26 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search


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 Database Server, Recital Mirage Server, Recital Terminal Developer