Error-handling, Variable instead of Identifiers
I have propably 2 easy questions, but I am not able to manage these problems
on my UNIX(r) System V Release 4.0 (MX300I) SIEMENS, Release 5.41
Version A0010 and INFORMIX-4GL, Version 4.10.U.
1. If I use an error-handling to recognize an already existing table
'table_1' before I create it, the programm jumps in my error-function
and then to a function, that drops this table_1.
after this my programm should create the new table_1, but INFORMIX
now overrides the command, which caused the error.
How can I ensure that INFORMIX repeats this command? The same happens with
CREATE INDEX ...
MAIN
WHENEVER ERROR CALL error_handle;
CREATE TABLE table_1 (...); ...
END MAIN
FUNCTION error_handle()
LET in_last_status = status;
CALL ERR_PRINT(in_last_status);
CASE (in_last_status)
WHEN -310
CALL delete_table();
END CASE;
END FUNCTION
FUNCTION delete_table()
DROP TABLE table_1; END FUNCTION
2. In this example I can't use a variable, instead of an Identifier 'table_1'.
So if I have to drop some more tables or indexes I have to write a huge amount
of CASE ...-commands. Is there a solution?
Thanks for your help. Hope, I don't jump on your nervs, but I'm a beginner in INFORMIX-4GL!
+++++++++++++ Martin Baier ++++++++++++++++
++++ martin.baier@wiwi.uni-regensburg.de ++++
+++++++++ student of economics ++++++++++++
+++++++ and this concerns my thesis +++++++++