ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Find Source Member Across Libraries ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Find Source Member Across Libraries ?

    I have a situation where the CL Source code is not in the library I expected it to be in. Does anyone have an idea how to search for source code for PROGRAMA in all QCLSRC files in all libraries ?

    Also, when I run DSPOBJD MYLIB\PROGRAMA then opt 8 "Display Service Attributes", SOURCE FILE & LIBRARY are blank.

  • #2
    In RDi, do a CTRL-H or the IBM i Search from the toolbar.

    Comment


    • #3
      I set up all my source libraries as object filters in RDi. In the object filter I filter to only PF-SRC files.

      Then you can right click on one or many libraries and select 'find string'

      This will search every source file in each of the selected libraries.

      Comment


      • #4
        I don't have RDI. Maybe I can make a SQL query looking at files & members across libraries.

        EDIT

        select *
        from (select ROW_NUMBER() OVER () row#, TABLE_SCHEMA , TABLE_NAME , TABLE_PARTITION , PARTITION_TEXT
        FROM QSYS2.SYSPARTITIONSTAT
        WHERE TABLE_NAME LIKE 'QCL%'
        AND TABLE_PARTITION = 'SourceMemberName'
        )
        ORDER by TABLE_PARTITION ;
        Last edited by MFisher; June 9, 2021, 12:27 PM.

        Comment

        Working...
        X