SET GATEWAY

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