Member Active Retrieval

This document covers the following topics:

Displaying the Member Active Retrieval Screen

The Member Active Retrieval screen is displayed with function code A and object code ME in a main menu or the command ACTIVE MEMBER. 

    13:44:44             *****  P R E D I C T  *****              2007-05-31
    Plan   3              - (ME) Member Active Retrieval -               Profile HNO
   
     Retrieval type                             Retrieval type
   
     I  Members                                 O  Members not documented
     R  Entries referenced by members           T  Members with used files
     U  Entries not referenced                  V  Members using dynamic SQL
                                                M  Members referenced by members
   
    Retrieval type .....
    Output mode .......*
    Member .............                                User system Fnr ..
    Library ............                                User system DBnr .
    From catalog date .. 0000-00-00 (YYYY-MM-DD)        Member of type ..*
    To catalog date .... 2007-05-31 (YYYY-MM-DD)
    Entry ..............
   
   
    Output options ....*   Profile HNO                  Save set ......... N (Y/N)
   
    Command ===>
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Next  Stop  Last  LnkEl Flip  Print Impl  AdmFi SelFi Prof  Main

Member Active Retrieval functions show where and how entry points, members and files are referenced by implemented members.

Retrieval Type, Output Mode and Save Set Option

An active retrieval operation consists of a retrieval type and an output mode. The retrieval types are described in more detail below. The output mode determines how the results are presented. Not all output modes are valid for all retrieval types. See table below.

Retrieval Type Code   Save Set
select list disp count
Members I X X     X
Entries ref. by members R X X   X X
Entries not referenced U X X      
Members not documented O X X      
Members with used files T   X      
Members using dynamic SQL V X X     X
Members ref. by members M   X     X

The results of retrieval types I, R, M and V can be saved in sets and processed with the Natural command LIST XREF, the Natural Object Handler, the Natural utility SYSMAIN or with Natural ISPF.

Limiting the Scope of Member Active Retrieval

Not all parameters are valid for all retrieval types. See table below.

Parameter Retrieval Type
I R U O T V M
Member X X X X X X X
User system Fnr X X X X X X X
Library X X X X X X X
User system DBnr X X X X X X X
Member of type X X   X X X X
From catalog date X     X X X X
Entry   X X        
Output options   X X        
Parameter Description
Member Restricts operation to member with ID specified. Use asterisk to specify range.

User system Fnr
Library
User system DBnr

These three parameters restrict the operation to members with the implementation pointer specified. Enter asterisk to specify range.
From catalog date Restricts the operation to members that have been cataloged after the given date. Default=0000-00-00.
Member of type Identifies the type of member to be retrieved. Enter asterisk for valid values.
To catalog date Restricts the operation to members that have been cataloged before the given date. Default value is the current date.
Entry Point of reference into an external program.
Output options Output options determine the amount of information contained in a report. Output options can be specified temporarily with code T in the field Output options or taken from a profile. Enter asterisk for valid values or see Output Options for more information.

Retrieval Types

Members - Code I

Provides information on implemented members, their entry points and corresponding program descriptions in the data dictionary. Output mode L or S must be specified:

Output Mode Description
L

Shows for each member: Type, language, file number, database number of the member; User-ID, terminal-ID, date and time of cataloging, entry points; Documented program together with implementation pointer.

If the program is documented: Entry points of the member which are not yet documented are marked <<< not documented.

Command: LIST MEMBER
S Produces a list of files with the following information:
Type, language, file number, database number of the member;
Program in which the member is documented or the screen text >>>Member not documented<<<.

List can be used to select members for further processing or add commands to the workplan. Enter an asterisk in field Cmd for list of possible functions. Command: SELECT MEMBER.

Entries referenced by members - Code R

Provides information on members which refer to the specified external entry. Output mode L, S or C must be specified:

Output Mode Description
L Lists members which refer to the specified external entry.

Command: REFERENCED ENTRY
S Shows a list of members which refer to the specified external entry. Members can be selected from list.
C Lists the libraries which use the specified external entry and indicates the number of references per library.

Command: COUNT ENTRY

Entries not referenced - Code U

Provides information on entry points which are not referenced by any other member. Output mode L or S must be specified:

Output Mode Description
L Lists for each member the entry points that are not referenced by any other member sorted by documented program.

Command: UNUSED ENTRY
S Produces selection list as above from which entry points can be selected for further processing.

Members not documented - Code O

Provides information on members which have been cataloged or precompiled but are not documented in Predict. Output mode L or S must be specified:

Output Mode Description
L Lists undocumented members. The following information is also given:
Type, language, file number, database number of the member;
User-ID, terminal-ID, date and time of cataloging.

Command: UNDEFINED MEMBER
S Produces selection list of undocumented members. The following information is also given:
Type, language, file number, database number of the member;
ID of user who cataloged the member.
Members can be selected from this list for further processing.

Members with used files - Code T

Provides information on files referred to by the specified member.

Command: ELEMENTS MEMBER

Output mode L must be specified:

Output Mode Description
L Lists members and the files that they use. Members that do not refer to any file are marked >>>>no file used<<<<. Files documented in Predict are marked with D.

Members using dynamic SQL - Code V

Provides information on Natural members that use DB2 tables and views (file types D or E) but not via Static SQL.

This function does not apply to 3GL members. Output mode L or S must be specified:

Output Mode Description
L Lists members. Some main attributes as well as user ID, terminal ID, date and time of cataloging are also given.

Command: DYNAMIC MEMBER
S Produces list of members, from which members can be selected for further processing or commands added to the workplan.

Members referenced by members - Code M

Provides information on members that refer to the specified member.

This function corresponds to the LIST XREF functions

  • “Program referenced in programs” in the “Invoked programs” subsystem

  • “Data area referenced in programs” in the “Data Area and Variables” subsystem

  • “Copycode referenced in programs” in the “Copycode” subsystem

But in difference to LIST XREF, this function does not consider any steplibs structures. This means that all references to a member are shown, which are part of the Xref data.

Output mode L must be specified:

Output Mode Description
L Lists members that refer to the specified member.

Command: REFERENCED MEMBER