Difference between revisions of "GATEWAY()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Returns information about a gateway connection
 
Returns information about a gateway connection
Line 51: Line 49:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Data Connectivity]]
+
[[Category:Remote Data Connectivity]]
[[Category:Data Connectivity Functions]]
+
[[Category:Remote Data Connectivity Functions]]

Latest revision as of 11:51, 22 June 2010

Purpose

Returns information about a gateway connection


Syntax

GATEWAY([<expN>])


See Also

CONNECTED(), CREATE GATEWAY, MODIFY GATEWAY, SET GATEWAY

Description

The GATEWAY() function returns specified information about the connection to the Recital Database Gateway in the current workarea. The following table lists the optional information that may be requested.


Value Description
Returns the server type, Recital, Oracle, ODBC, Informix, DB2, etc
0 Returns the server type, Recital, Oracle, ODBC, Informix, DB2, etc
1 Returns the node name that the gateway is connected to.
2 Returns the user name that was used to connect to the gateway.
3 Returns the password associated with the user name.
4 Returns the database connected to on the server.


Example

login "oracle"
?gateway()
Oracle
? gateway(1)
sales
? gateway(2)
scott
? gateway(3)
tiger
? gateway(4)


Products

Recital Server, Recital