Recently to meet demand, usage scenarios is that from an informix database query data filling to another in the library; When the informix database queries will be a lot of complex logic, so when doing the design finished first in DBV written in SQL execution no problem, but when moved to the project was dumbfounded, incredibly error can't find that temporary table; Has been used in mysql before
CREATE TEMPORARY TABLE tmp_table SELECT * FROM table_name;
Used in informix
SELECT * FROM table_name into temp tmp_tbname with no log.

Special table tmp_tbname mybaties error does not exist, so I want to solve this problem, send this post for help, and I said I need

To create a temporary table in mybaties using informix and use temporary table
For example,
SELECT * FROM table_name into temp tmp_tbname1 with no log.

SELECT * FROM tmp_tbname1 into TMP tbname2 with no log.

SELECT * FROM tmp_tbname2 into tmp_tbname3 with no log.


A novice very eager to solve this problem, please everyone help to solve, if there are better ways, please also provide the! Grateful to

CodePudding user response:

Informix temporary table is session,
If you use the connection pool, two operations may not be another session, so may be unable to find a temporary table,