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. |
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 installatation instructions and a description of the Natural for SQL/DS parameter module, refer to Installing Natural for SQL/DS in the Installation for z/VSE documentation.
For the various aspects of accessing data in a database with Natural, see also Database Access 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.