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 IBM's DB2 Server for VSE & 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. |
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.