Difference between revisions of "CREATE GATEWAY"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→Class) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Create a gateway file | Create a gateway file | ||
| Line 15: | Line 13: | ||
==Description== | ==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 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: | 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: | ||
| Line 40: | Line 36: | ||
|Table Primary Key||The primary index key for the table | |Table Primary Key||The primary index key for the table | ||
|- | |- | ||
| − | |Table Restriction||An optional SQL | + | |Table Restriction||An optional SQL SELECT...WHERE clause |
|- | |- | ||
|} | |} | ||
| − | + | The Local Client area of the form is no longer used. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 14:19, 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
