Morning,
Anyone using Informix temp tables in a DS project? Probably doesn't work, but asking anyway.[:D]
Steve
Informix temp tables possible?
Moderators: chulett, rschirm, roy
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.
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.