Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Global Temporary Table-Help required

    Hello,

    In our application, Global Temporary Table is used. It's j2ee/(jdbc)/db2 application.
    At certain points following kind of query UPDATE "SESSION"."CBR_TEMPCASE8504" T SET CASESTATICSIMSCORE = coalesce(....)
    throws following excetion
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0204N "SESSION.CBR_TEMPCASE8504" is an undefined name. SQLSTATE=42704

    DECLARE statements are used to create the tables with ON COMMIT PRESERVE ROWS NOT LOGGED option, IN USER TEMPORARY TABLESPACE .
    We have ensured that single connection will be used till the point queries to be fired on temporary table and upon completion connection is closed.
    Any suggestion/enlightenment on other probable causes is welcome.

    Regards,
    Manimala

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    Are you declaring your GTT in a servlet and trying to reuse it in another one? Remember: a GTT exists only for one session (this is why the qualifier is named SESSION ;-) )
    Rodney Krick

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Global Temporary Table

    No, no not in servlet.
    Single object and connection is given

Posting Permissions

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