@%#$@!% RDS 6.01
Posted in 1995
Aaarrrgggghhh!!!!!
I have come across an inconsistency in the new RDS (6.01.UC1). A longtime
ago we decided on a standard for naming temporary tables so that we would
never have a problem of someone creating a real table of the same name
and causing problems for our programs. We decided on using __ in front of
the table name. This worked fine in 4.1
Now I find when I am testing my programs after recompiling for the new
Informix that I get a -201 error on the following statement:
SELECT * FROM table_x INTO TEMP __table_x
I do it this way as I want to make sure that the temp table mirrors the real
table. I can still select from __table_x, delete from __table_x and load into
__table_x but just that initial statement gives an error.
We have used this quite extensivly. Before I have to go and bite any bullets
I would like to know if:
a) this is fixed in a newer version (pleasee!!!)
b) there is a magical command line arguement that gets around it
c) there are any good vacancies for 4gl analyst/programmers around
TIA
Jason.
PS: Did you know that when you execute a database statement (ie database stores)it not only closes all open cursors but frees them as well and you need to
redeclare the cursors before you can use them!