Difference between revisions of "CREATE GATEWAY"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 39: | Line 39: | ||
|- | |- | ||
|} | |} | ||
| + | |||
The Local Client area of the form is no longer used. | The Local Client area of the form is no longer used. | ||
Revision as of 14:21, 9 November 2009
Purpose
Create a gateway file
Syntax
CREATE GATEWAY <.gtw filename> | (<expC>)
See Also
GATEWAY(), LOGIN, LOGOUT, MODIFY GATEWAY, SET GATEWAY
Description
The CREATE GATEWAY command is used to create a gateway file to an external SQL database table. See Supported Data Sources for the SQL Databases that can be accessed on each individual platform.
The CREATE GATEWAY worksurface provides a full screen facility for gateway creation in Recital Terminal Developer. The <.gtw filename> can be substituted with any character expression, enclosed in round brackets, that returns a valid filename. If no file extension is specified, then .gtw is used. The following elements can be defined for the gateway:
| Server Element | Description |
|---|---|
| Name | The remote server name, e.g. Oracle |
| Network Node Name | The node name or IP address of the server |
| Protocol Type | The connection protocol, DECNET or TCP/IP |
| Login Username | The login for the server |
| Login Password | The login password for the server |
| Database Name | The full name (including path if applicable) of the database |
| Table Name | The table name from the database |
| Table Primary Key | The primary index key for the table |
| Table Restriction | An optional SQL SELECT...WHERE clause |
The Local Client area of the form is no longer used.
Example
create gateway employees
Products
Recital Terminal Developer
