Natural for SQL/DS

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.

Related Documentation

For installation 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.