Informix temp tables possible?

inter5566 · Post by **inter5566** » Fri Jul 11, 2003 9:24 am

Morning,
Anyone using Informix temp tables in a DS project? Probably doesn't work, but asking anyway.[:D]

Steve

kduke · Post by **kduke** » Fri Jul 11, 2003 9:40 am

inter5566

It depends on how you setup temp tables. Temp tables are automatically deleted after a session closes in some databases which means no you cannot use these tables. If you import metadata from it then you can probably use it.

Kim.

roy · Post by **roy** » Sun Jul 13, 2003 12:09 pm

Hi,
well your problem is probably due to the fact you are actually in another connection when trying to select the temp table you built,
hence can't access the temp table !!!

a simple "work around" if you might call it is to use actual tables, you build on the before sql statement. after you fetch the data you need in the after sql use drop table.

p.s.
I've encounterd some isues concerning the max length of the sql the informix deriver accepts, so if you get the same problem you might want to have the table generated via dbaccess and using the before/after sql to empty the table so it won't take to much of your dbspace.
the only down side is that the table will exists constantly and the delete statement might run a bit slow.

hope this helps,

Roy R.