Difference between revisions of "CREATE GATEWAY"

From Recital Documentation Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
+
''Deprecated in Recital 10''
Data Connectivity
+
 
+
  
 
==Purpose==
 
==Purpose==
Line 17: Line 15:
 
==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 GATEWAY method allows SQL database tables to be accessed via the Recital forms interface.  This requires the creation of a gateway file and an empty Recital table that has a structure matching that of the external file.  By convention, the empty structure file is given the file extension '.str' rather than the default '.dbf'.  SQL Databases can also be accessed directly using Passthrough SQL.  For more information on Recital/SQL capabilities, please see the Recital/SQL documentation.
 
  
 
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 42: 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 SELECT…WHERE clause
+
|Table Restriction||An optional SQL SELECT...WHERE clause
 
|-
 
|-
 
|}
 
|}
  
  
{| class="wikitable"
+
The Local Client area of the form is no longer used.
!Client Element||Description
+
|-
+
|Structure Name||The name of the matching Recital structure table
+
|-
+
|Alias Name||The alias name for the client table
+
|-
+
|Default Form Name||The default screen form to be used
+
|-
+
|}
+
  
  
Line 66: Line 53:
  
 
==Products==
 
==Products==
Recital Terminal Developer
+
Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Terminal Development Tools]]
 
[[Category:Terminal Development Tools]]
 
[[Category:Terminal Development Tools Commands]]
 
[[Category:Terminal Development Tools Commands]]
[[Category:Data Connectivity]]
+
[[Category:Remote Data Connectivity]]
[[Category:Data Connectivity Commands]]
+
[[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