LISTDBRMhas to be issued from the Natural system library
SYSDB2, which means you have to log on to
SYSDB2first and then enter the command
LISTDBRMhas to be issued from library
SYSSQL, which means you have to log on to
SYSSQLfirst and then enter the command
LISTDBRM command is used to display either existing
DBRMs (Natural for DB2) or existing packages (Natural for SQL) of Natural
programs or Natural programs referencing a given DBRM.
When the command is used with Natural for DB2 or Natural for SQL/DS, the following menu is displayed:
14:29:18 ***** NATURAL TOOLS FOR SQL ***** 2010-02-02 - List DBRM - Code Function D Display DBRMs of Programs R List Programs Referencing DBRM ? Help . Exit Code .. _ Library .. ________ Member ... ________ DBRM ..... ________ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Canc
The following functions are available:
||Displays programs that have access to DB2 (Natural for DB2) or
SQL/DS (Natural for SQL/DS), and their corresponding package (DBRM).
If no DBRM name is shown, the corresponding program uses dynamic SQL.
||Lists all programs that use a given package (DBRM). If no DBRM name is specified, all programs that use dynamic SQL are listed.|
The following parameters apply:
|Library|| Specifies the name of a Natural library.
Library names beginning with
|Member|| Specifies the name of the Natural program (member) to be
This parameter is optional and can be used to limit the output.
If a value is specified followed by an asterisk (*), all members in the specified library with names beginning with this value are listed.
If the Member field is left blank, or if an asterisk is specified only, all members in the specified library are listed.
|DBRM|| Specifies a valid package (DBRM) name.
If left blank, programs that run dynamically are referenced.
This parameter applies to function code
14:29:22 ***** LISTDBRM Command ***** 2010-02-02 Library Name Type DBRM User ID Date Time -------- -------- ----------- -------- -------- -------- -------- EXAMPLE PROG1 Program PACK1 SAG 2006-03-17 11:10:43 EXAMPLE PROG2 Program PACK1 SAG 2006-03-17 11:10:48 EXAMPLE PROG3 Program PACK2 SAG 2006-03-17 11:11:04 EXAMPLE PROG4 Program SAG 2006-03-17 11:11:07