The following table shows how the SQL of a Natural program is executed in an NDB and an NDZ environment either dynamically or static depending on the static generation mode and the Natural execution mode.
| Static generated NDB | Static generated NDZ | Executed with NDB | Executed with NDZ | Run with NDB | Run with NDZ | |
|---|---|---|---|---|---|---|
| Yes | Yes | Static | Static | Dynamic | Dynamic | |
| Yes | No | Static | Dynamic | Dynamic | Dynamic | |
| No | Yes | Dynamic | Static | Dynamic | Dynamic | |
| No | No | Dynamic | Dynamic | Dynamic | Dynamic |
Note:
If a program is recatalogued, both NDB and NDZ static information is lost and the
program is converted back in dynamic mode.