Difference between revisions of "CREATE GATEWAY"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (9 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ''Deprecated in Recital 10'' | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
==Purpose== | ==Purpose== | ||
| Line 15: | Line 10: | ||
==See Also== | ==See Also== | ||
| − | [[GATEWAY()]], [[LOGIN]], [[ | + | [[GATEWAY()]], [[LOGIN]], [[LOGOUT]], [[MODIFY GATEWAY]], [[SET GATEWAY]] |
==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 45: | Line 38: | ||
|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. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| Line 69: | Line 53: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Terminal Development Tools]] | ||
| + | [[Category:Terminal Development Tools Commands]] | ||
| + | [[Category:Remote Data Connectivity]] | ||
| + | [[Category:Remote Data Connectivity Commands]] | ||
Latest revision as of 11:47, 22 June 2010
Deprecated in Recital 10
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
