Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Unanswered: How can I detect if a temp table already exist

    Hi,
    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    SE is a weird situation. It will create temporary files in your DBTEMP directory.

    You could always do a

    select * from temptable
    where 0=1

    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...
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •