With Natural SQL Gateway, a Natural user residing on z/OS can access data in an SQL database residing either on a UNIX or a Windows system.
This documentation describes the client and server parts of Natural SQL Gateway.
It is organized under the following headings:
| Using Natural SQL Gateway | ||
|---|---|---|
|
|
General Information | Introduction to Natural SQL Gateway, information on how to access SQL tables, on the integration with Software AG's Data Dictionary Predict, and on error messages related to Natural SQL Gateway. |
|
|
Installing Natural SQL Gateway | Installation of the Natural SQL Gateway and description of the Natural SQL Gateway parameter module. |
|
|
Natural System Commands for the Natural SQL Gateway | Describes special Natural system commands for the use with the Natural SQL Gateway. |
|
|
DDM Generation | Generation of Natural data definition modules (DDMs) using the
SQL Services function of the Natural SYSDDM utility.
|
|
|
Dynamic SQL Support | Internal handling of dynamic statements. |
|
|
Statements and System Variables | Special considerations on Natural DML statements, Natural SQL
statements and Natural system variables when used with SQL. In addition, the
Natural SQL Gateway enhanced error handling is discussed.
Note: |
|
|
Interface Subprograms | Several Natural and non-Natural subprograms to be used for various purposes. |
|
|
Natural File Server | Description of the Natural File Server in the various supported environments. |
|
|
Environment-Specific Considerations | Special considerations on the various environments supported by Natural SQL Gateway . |
|
|
Incompatibilities and Constraints | Known incompatibilities and constraints when using Natural SQL Gateway. |
| Using Natural SQL Gateway Server | ||
|
|
Natural SQL Gateway Server Concept | Concept and structure of the server for Natural SQL Gateway. |
|
|
Installing the Natural SQL Gateway Server under z/OS | How to install a server for the Natural SQL Gateway under the operating system z/OS. |
|
|
Configuring the Natural SQL Gateway Server | How to configure the Natural SQL Gateway server. |
|
|
Operating the Natural SQL Gateway Server | How to operate the Natural SQL Gateway server. |
|
|
Monitor Client
NATMOPI |
Purpose and use of the monitor client
NATMOPI.
|
|
|
HTML Monitor Client | Purpose and use of the HTML monitor client. |
For various aspects of accessing data in a database with Natural, refer to Accessing Data in a Database.
For information on logging SQL statements contained in a Natural program, refer to DBLOG Utility in the Natural Utilities documentation.
