Version 4.2.6
 —  Database Management System Interfaces  —

Using Natural System Commands for DB2

The following Natural system commands have been incorporated into the Natural Tools for DB2:

Natural System Command Explanation
LISTSQL Lists Natural DML statements and their corresponding SQL statements.
LISTSQLB Provides explanations of SQL statements for a specific object.
SQLERR Provides information of the SQLCA on a DB2 error.
SQLDIAG Provides diagnostic information about the last SQL statement (other than a GET DIAGNOSTICS statement) that was executed.
LISTDBRM Displays either a list of DBRMs (database request modules) for a particular Natural program or a list of Natural programs that reference a particular DBRM.

For a description of these commands, follow the links leading to the Natural System Commands documentation.

Top of page