set mode lazy=on

I'm being lazy, and asking if anyone's needed to do this before and has a script, to save me writing it again. I have a schema with about 2,000 foreign keys. Most fks have a an underlying user-defined index on the child table, but a handful do not. I need to identify this handful. Has anyone ever tried to do this, either through a systables query or some kind of clever awking of the dbschema file. Thanks Neil

Set mode lazy_answer = on Yes :) Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NEIL TRUBY Sent: Monday, July 16, 2012 11:49 AM To: ids@iiug.org Subject: set mode lazy=on [27613] I'm being lazy, and asking if anyone's needed to do this before and has a script, to save me writing it again. I have a schema with about 2,000 foreign keys. Most fks have a an underlying user-defined index on the child table, but a handful do not. I need to identify this handful. Has anyone ever tried to do this, either through a systables query or some kind of clever awking of the dbschema file. Thanks Neil **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Neil, just look for index names in sysreferences that start with a space character. Art On Jul 16, 2012 12:49 PM, "NEIL TRUBY" <neil.truby@ardenta.com> wrote: > I'm being lazy, and asking if anyone's needed to do this before and has a > script, to save me writing it again. > > I have a schema with about 2,000 foreign keys. Most fks have a an > underlying > user-defined index on the child table, but a handful do not. I need to > identify this handful. > > Has anyone ever tried to do this, either through a systables query or some > kind of clever awking of the dbschema file. > > Thanks > Neil > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340525ef2df404c4f57894