Search all tables for data

Posted in 2006

C Douglas — 20 Jan 2006 11:06:02 -0800 — source: Usenet: comp.databases.informix

I have a 4GL report that I would like to find what tables it is pulling data from, but I don't have the source code. Is there an SQL statement that will search all tables in the database and return the table and column names that contain the data? On the report I have a date and quantity sold amount that I would like to search for. The database is Informix SE 7.23.UC13.