LISTPROF

#### Search Results

Search

# LISTPROF

`LISTPROF`

Notes:

1. This command is only available with Natural for Db2.
2. `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 `SYS` are not permitted.This parameter must be specified.
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 `R` only.

#### Sample List DBRM Result Screen

         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