Re: Search an object within a database

Posted in 2004

gsturkenboom@lic.co.nz — Tue, 24 Aug 2004 12:22:15 +1200 — source: Usenet: comp.databases.informix

You don't give an OS or database version. I would use dbschema saving the output to a file then grep. We are on Solaris 9 IDS 7.30. "N" <N@N.COM> Sent by: To: informix-list@iiug.org owner-informix-li cc: st@iiug.org Subject: Search an object within a database 24/08/2004 09:38 Please respond to "N" Hi, Is there an easy way to search for a specific object within the database ? For example, I need to find where a specified function is being used throughout the database (in views and other SPLs). I wrote a simple select statement to run against systables to find a specific column name. But I'm stuck with this one. Anyone can help me ? Thank you. sending to informix-list