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>'