LISTPROF |
Notes:
LISTPROF
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 LISTPROF.
The LISTPROF
command is used to display existing SQLJ profiles of Natural
programs or Natural programs referencing a given SQLJ profile.
When the command is used, the following menu is displayed:
14:29:18 ***** NATURAL TOOLS FOR SQL ***** 2023-02-16 - List SQLJPROF - Code Function D Display SQLJ Profiles of Programs R List Programs Referencing SQLJ Profiles ? Help . Exit Code .. _ Library .. ________ Member ... ________ SQLJPROF . ________ 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 and their corresponding SQLJ profile.
If no SQLJ profile name is shown, the corresponding program uses dynamic SQL. |
R |
Lists all programs that use a given SQLJ profile. If no SQLJ profile 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. |
SQLJPROF | Specifies a valid SQLJ profile name.
If left blank, programs that run dynamically are referenced. This parameter applies to function code |
16:16:22 ***** NATURAL TOOLS FOR SQL ***** 2023-02-16 - List SQLJPROF - Library Name Type SQLJPROF User ID Date Time -------- -------- --------- -------- -------- -------- -------- HGK P017523 Program HGK 2011-02-23 16:16:25 HGK P017622 Program P017622 HGK 2023-02-02 17:51:32 HGK P017622D Program P017622 HGK 2022-12-13 16:08:16 HGK P017622F Program P017622 HGK 2022-12-13 16:08:16 HGK P017622R Program P017622 HGK 2022-12-13 16:08:16 HGK P017622U Program P017622 HGK 2022-12-13 16:08:16 HGK P017948C Program HGK 2011-05-31 10:41:06 HGK P017948D Program HGK 2011-05-27 16:07:05 HGK P017948X Program HGK 2011-05-31 09:45:54 |