Difference between revisions of "GATEWAY()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Returns information about a gateway connection | Returns information about a gateway connection | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[CONNECTED()]][[CREATE GATEWAY]], [[MODIFY GATEWAY | + | [[CONNECTED()]], [[CREATE GATEWAY]], [[MODIFY GATEWAY]], [[SET GATEWAY]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 20: | Line 15: | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | !Value|| | + | !Value||Description |
| − | + | ||
|- | |- | ||
|||Returns the server type, Recital, Oracle, ODBC, Informix, DB2, etc | |||Returns the server type, Recital, Oracle, ODBC, Informix, DB2, etc | ||
| Line 55: | Line 49: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Remote Data Connectivity]] | ||
| + | [[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
