Members on our team have a massive database that's housed in DB2 for i server that they are accessing through SQL Explorer. But the tables aren't very well documented and they're trying to do a few things with it.
Search the entire database that look for tables with a column called "Remarks"
Search the column for a keyword
And a table returned which includes the names of the tables that includes the keywords.
Here's what I tried so far:
WHERE Remarks LIKE '<keyword>'
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!