Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Radio Spares — — source: Informix-list mailing list archive (1991-1998)
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!
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.