This documentation describes the functionality and the use of Natural for SQL/DS, which is a Natural interface required to access data in a SQL/DS database.
This documentation is organized under the following headings:
General Information | Information such as purpose, special considerations on the various environments supported by Natural for SQL/DS, integration with Software AG's Data Dictionary Predict, incompatibilities and constraints, error messages related to SQL/DS, and terms used in this documentation. | |
Installing Natural for SQL/DS | Installation of the Natural interface to SQL/DS and description of the Natural for SQL/DS parameter module. | |
Accessing an SQL/DS Table | Enable access to an SQL/DS table with a Natural program. | |
Database Management | Maintenance of SQL/DS tables and other SQL/DS objects with the
SYSSQL utility; Natural system commands for SQL/DS.
|
|
Generating Natural Data Definition Modules (DDMs) | Generation of Natural data definition modules (DDMs) by using the
SQL
Services function of the Natural utility
SYSDDM. |
|
Dynamic and Static SQL Support | Internal handling of dynamic statements, creation and execution of static DB access modules (SQL/DS packages) in the various supported environments, mixed dynamic/static mode. | |
Using Natural Statements and System Variables | Special considerations on Natural native DML statements, Natural SQL statements, Natural system variables, and Natural for SQL/DS error handling. | |
Interface Subprograms | Several Natural and non-Natural subprograms to be used for various purposes. |
For the various aspects of accessing data in a database with Natural, see also Accessing Data in a Database in the Natural Programming Guide.
For information on logging SQL statements contained in a Natural program, refer to DBLOG Trace Screen for SQL Statements in the DBLOG Utility documentation.