David properly shamed me for not including IDS Version and OS Version.
I tested 9.40.FC4 on Solaris 8 and AIX 5L. I also tested 9.40.TC6 on Windows 2000 Server. OS is irrelevant, therefore, to reproduction.
In my defence - and it is a feeble one - I did say that sysindexes is a view, so that eliminates IDS 7.3 and earlier. Otherwise, I can only beg for mercy on the grounds that it is the end of the year and I am trying to keep this little beauty from disrupting my holiday plans (specifically, I plan not to rewrite all my code which uses subqueries in views).
In remorse, I will happily offer the presidency of the KCIUG Steering Committee to the first sucker^wnoble volunteer willing to take on this grave responsibility.
Sincerely,
Christopher Coleman
Steering Committee President
Kansas City Informix Users Group
www.iiug.org/kciug
Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
sending to informix-list