Hi,

I am runing a program that create a temp table, and to go out of the program, when I runing the program the next time the program give me the followind error:

Program error at "prcuabul.4gl", line number 650.
SQL statement error number -958.
Temp table (reset.tcuabu2) already exists in session.


Thank you.

Are you sure that the program disconnects from
the databaseserver, so that the session is
destroyed ?

Normally all temp tables will be destroyed as soon as
the database session terminates.

Check your database session with "onstat -u" and
"onstat -g ses <ses_id>" when running the program.

After terminating the program, check this again to be sure
that the session is destroyed.

After using the temporary table, try to drop the table by issuing a SQL statement DROP TABLE <Temporary Table Name>. Be careful in dropping tables. Temporary table are only drop after disconnection/session if not dropped explicitly.