CREATE GATEWAY

Class

Data Connectivity

Purpose

Create a gateway file

Syntax

CREATE GATEWAY <.gtw filename> | (<expC>)

See Also

GATEWAY(), LOGIN, LOGOUT, 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 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:

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

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

Example

create gateway employees

Products

Recital Terminal Developer