LISTDBRM |
Notes:
LISTDBRM has
to be issued from the Natural system library SYSDB2, which means
you have to log on to SYSDB2 first and then enter the command
LISTDBRM.LISTDBRM
has to be issued from library SYSSQL, which means you have to log
on to SYSSQL first and then enter the command
LISTDBRM.
The 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:
| Code | Description |
|---|---|
D |
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. |
R |
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:
| Parameter | Description |
|---|---|
| Library | Specifies the name of a Natural library.
Library names beginning with |
| Member | Specifies the name of the Natural program (member) to be
displayed.
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 |