Tripping Server - Last Gasp

%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Tripping Server - Last Gasp %VERIFY y %DATE 24/02/93 12:13 %REFERENCE 14365 Hello again! I posted a query on this problem a while back but there wasn't too much of a response so here goes again. Our local Informix support told us that this problem was bug number 12566 and was fixed in I-Star Ver 4.10.UE5 and later versions. We have tested it using Online 4.10.UG1 and I-Star 4.10.UG1 and (surprise, surprise!) the problem is still happening. They have now decided that it isn't that bug after all and have ridden off on a mystery tour that has lasted over a week now, with no visible results. The problem is fairly easy to duplicate, as the code below will show: Is there anyone out there (Someone from Informix perhaps?) who can test this and tell us exactly which versions to avoid ? This is very important to us as one of our major applications depends on this piece of code working. The Error message: SQL statement error number -211 Cannot read system catalog (systables). System error number -101. ISAM error: file is not open. The Code: ********************************************************** database db1 define query char(200) define tab1_exists, tab2_exists smallint main let tab1_exists = false let tab2_exists = false call first_function() call second_function() call first_function() call second_function() end main function first_function() if temp1_exists then drop table temp1 end if prepare query2 from "select anything from table1 into temp temp1" execute query2 let temp1_exists = true end function function second_function() if temp2_exists then drop table temp2 end if select anything from other_db:table into temp temp2 let temp2_exists = true end function ********************************************************** %UEND