Re: Search all tables for data

Posted in 2006

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Superboer — 22 Jan 2006 07:23:38 -0800 — source: Usenet: comp.databases.informix

export SQLIDEBUG=2:/<somefilesystem with lots of space>/<somefile> run your report, use sqliprint (comes with csdk ) on the produced file or use strings /<somefilesystem with lots of space>/<somefile> this will dump all including the sql to stdout. also: strings <your report> may give you the answer. Superboer. C Douglas schreef: > 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.

↪ replying to Superboer

C Douglas — 22 Jan 2006 09:07:20 -0800 — source: Usenet: comp.databases.informix

> strings <your report> may give you the answer. I don't have sqliprint, but the strings command gave me what I was looking for.

Glossary

4GL (Informix-4GL)