Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Temp table (reset.tcuabu2) already exists in session.

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Feb 2003
    Posts
    24

    Temp table (reset.tcuabu2) already exists in session.

    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.

Posting Permissions

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