myITforum and Windows IT Pro Forums

 Search tables for a string

Author Message

  • Total Posts : 1
  • Scores: 0
  • Reward points : 320
  • Joined: 3/7/2017
  • Status: offline
Search tables for a string Tuesday, March 07, 2017 11:20 AM (permalink)
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?

    • Total Posts : 3
    • Scores: 0
    • Reward points : 870
    • Joined: 3/17/2017
    • Status: offline
    Re:Search tables for a string Friday, March 24, 2017 10:08 AM (permalink)
    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.
      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2018 ASPPlayground.NET Forum Version 3.9