var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How can I detect if a temp table already exist
I am writing a database application using VB. My application rely heavily on temp tables.
My question is:
"How can I detect if a temp table already exist."
Mind you, that the database engine is “INFORMIX SE” running on a Unix machine. The connection to the database is done through ODBC.
SE is a weird situation. It will create temporary files in your DBTEMP directory.
You could always do a
select * from temptable
and check on syntax errors....
If it were IDS, an onstat -g ses <sess-id>
would give you the list of temporary tables of that session.
SE doesn't have a sysmaster database, so I don't know where it stores this information...