Re: Script to parse queries from code

mzanders@csci.csc.com (Mark Zanders) wrote: :Does anyone know of, or have any public domain software :that can extract all SQL from C code or 4gl, identifying :tables and columns, and what columns are used in the WHERE clause. No, and it's also hardly possible if the sql is built at runtime which is quite common. Why do you want to do it? If it's a running application you may turn on explain output (use "set explain on" in the code) and get the sql statements that are actually executed in the sqexplain.out file. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org