Using Natural System Commands for Db2

#### Search Results

Search

# 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.
`LISTPROF` | Displays either a list of SQLJ profiles (created by NDZ static generation) for a particular Natural program or a list of Natural programs that reference a particular SQLJ profile.

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