is there a way
Posted in 2005
jda — — source: Usenet: comp.databases.informix
We are running IDS Version 9.40.HC3 and upgraded from 7.31 about a month ago. I have a scripts I use to monitor the database and give me info on new tables, extents and other information. Since 9.4 has the indexes not attached all the indexes are showing up. Is there a way to identify whether a table in sysmaster:systabnames is a index or not, so I can skip the indexes? John David Adamski Information System Specialist Graceland University