Search tables for a string

Author
dreamlaw
New Member
  • Total Posts : 1
  • Scores: 0
  • Reward points: 320
  • Joined: 2017/03/07 10:13:39
  • Status: offline
2017/03/07 10:20:47 (permalink)
0

Search tables for a string

I need to search libraries/tables for a particular string. I have to use green screen so no RDI searches.
I can do a PDM search on each library but this only outputs to print. Is there a way of outputting to database file that can be searched?
#1

1 Reply Related Threads

    bbialt
    New Member
    • Total Posts : 3
    • Scores: 0
    • Reward points: 870
    • Joined: 2017/03/17 10:00:03
    • Status: offline
    Re:Search tables for a string 2017/03/24 09:08:10 (permalink)
    0
    You would probably need to develop an application to do this. 
    For starters you can access the libraries, tables, and column names from SYSIBM.SQLCOLUMNS.  
    I would create an RPG program or Stored procedure to  first build a list of Libraries/Tables you wish to search, then process this list, passing in your search string, and output the Library, Table, and Column results to an output database.
     
    #2
    Jump to:
    © 2018 APG vNext Commercial Version 5.5