This documentation describes the functionality and the use of Natural for Db2, which is a Natural interface required to access data in a Db2 database.
This documentation is organized under the following headings:
| General Information | Information such as purpose, environment-specific considerations, integration with Software AG's Data Dictionary Predict, incompatibilities and constraints, error messages related to Db2, and terms used in this documentation. |
| Accessing a Db2 Table | Enable access to a Db2 table with a Natural program. |
| Using Natural Tools for Db2 | Invoke Natural Tools for Db2 to maintain Db2-specific objects and SQL statements. |
| Application Plan Maintenance | Maintain Db2 application plans online. |
| Catalog Maintenance | Maintain the Db2 catalog. |
| Interactive SQL | Process SQL statements that are not embedded. |
| Retrieval of System Tables | Display/print Db2 objects and user authorizations. |
| Environment Setting | Execute SQL statements and display special register values. |
| Explain PLAN_TABLE | Interpret your PLAN_TABLE.
|
| File Server Statistics | Display statistics on the generation and use of the file server. |
| Issuing Db2 Commands from Natural | Issue Db2 commands from Natural. |
| Using Natural System Commands for Db2 | Use Natural system commands that have been incorporated into the Natural Tools for Db2. |
| Generating Natural Data Definition Modules (DDMs) | Generation of Natural data definition modules (DDMs) using the
SQL Services
function of the Natural SYSDDM utility.
|
| Dynamic and Static SQL Support | Internal handling of dynamic statements, creation and execution of static DBRMs, mixed dynamic/static mode, and application plan switching in the various supported environments. |
| Using Natural Statements and System Variables | Special considerations on Natural DML statements, Natural SQL statements, and Natural system variables with Db2. In addition, the Natural for Db2 enhanced error handling is discussed. |
| Processing Natural Stored Procedures and UDFs | Processing Natural stored procedures and Natural user-defined functions (UDFs). |
| Interface Subprograms | Several Natural and non-Natural subprograms to be used for various purposes. |
| Natural File Server for Db2 | Description of the Natural File Server for Db2 in the various supported environments. |
| Tracing Dynamic SQL Statements | Dynamic SQL Trace into shared memory object above the bar. |
For installation instructions and a description of the Natural for Db2 parameter module, refer to Installing Natural for Db2 in the Installation for z/OS 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.