Version 4.2.6
 —  Database Management System Interfaces  —

Natural for DB2

This documentation describes the functionality and the use of Natural for DB2 Version 4.3.1, which is a Natural interface required to access data in a DB2 database.

Note:
Information on Natural for DB2 Version 4.2.6 can be found in the earlier edition of the Natural Version 4.2.6 documentation on Software AG's Empower web site at https://empower.softwareag.com/.

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.

Installing Natural for DB2 Installation of Natural for DB2 and description of the Natural for DB2 parameter module.

Accessing a DB2 Table Enable access to a DB2 table with a Natural program.

Using Natural Tools for DB2 Invoke Natural Tools for DB2 and edit within the utilities available. Information on global PF-key settings and global maintenance commands.

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.

DB2 Commands Execution 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.

Related Documentation

For the various aspects of accessing data in a database with Natural, see also Accessing Data in a Database 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.

Top of page