Tripping Server II
%UNIPLEX
%TO informix-list@rmy.emory.edu
%FROM rridley
%SYSTEM DHLNET
%SUBJECT Tripping Server II
%VERIFY y
%DATE 23/12/92 20:10
%REFERENCE 9933
Hi there informixer's :
A while back I sent a mail asking if anyone had experienced problems
with Online 4.1 sending out error :
SQL statement error number -211
Cannot read system catalog (systables).
System error number -101.
ISAM error: file is not open.
We can now duplicate this with the following piece of code :
<========================================================>
DATABASE tst
DEFINE query2 char(1500)
main
CALL first_function()
CALL second_function()
CALL first_function()
CALL second_function()
end main
FUNCTION first_function()
WHENEVER error continue
DROP table 1st_temp_tab
WHENEVER error stop
PREPARE query2 from "SELECT rowid from any_table where
rowid = 1 into temp 1st_temp_tab"
EXECUTE query2
END function
FUNCTION second_function()
WHENEVER error continue
DROP table 2nd_temp_tab
WHENEVER error stop
SELECT unique col1,col2
FROM db2:table1
WHERE col1 = 8000089
and col2 = 35 into temp 2nd_temp_tab
END FUNCTION
<========================================================>
The program fails with the above error during the second instance of
'second_function', at the select statement.
We have noticed that, if we place 'FREE query2' (after removing the
DEFINE query2 statement ) after the 'EXECUTE query2' in the first
function, the program runs fine.
Has anyone experienced this problem with Online 4.1 before ?
Cheers,
Richard Ridley
%UEND