Version 4.2.5
 —  Database Management System Interfaces  —

Natural for SQL/DS

This documentation describes the aspects of Natural when used in an SQL/DS environment.

Explanation of Terms used in this Documentation:
SQL/DS refers to refers to IBM's DB2 Server for z/VSE and VM.
DB2 refers to IBM's DB2 UDB for z/OS.
Natural for SQL/DS is also referred to as NSQ.

General Information Information on how to access SQL/DS tables, on the integration with Software AG's Data Dictionary Predict, and on error messages related to SQL/DS.

Installing Natural for SQL/DS Installation of the Natural interface to SQL/DS and description of the Natural for SQL/DS parameter module.

Database Management Maintenance of SQL/DS tables and other SQL/DS objects with the SYSSQL utility; Natural system commands for SQL/DS.

DDM Generation 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.

Statements and System Variables Special considerations on Natural 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.

Environment-Specific Considerations Special considerations on the various environments supported by Natural for SQL/DS.

Related Documentation

See also Accessing Data in a Database for various aspects of accessing data in a database with Natural. For information on logging SQL statements contained in a Natural program, refer to the DBLOG Utility documentation in the section Debugging and Montitoring.

Top of page