Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Unanswered: Inserts ::TMP in DB2

    Hi all,

    What does the below Insert statement do
    I mean whats the Improtance of ::TMP here???

    INSERT INTO XXX_YYY :: TMP
    COLUMNS (.............)

    after executing the above Insert in a batch program, when I see the XXX_YYY table there is no row, but when I read the XXX_YYY with ::TMP it gives me data.
    Is ::TMP a mirror of the original table??
    If So, do we need another job to update the data to original table?
    'coz I cant see the changes on the screen as no data is available in XXX_YYY.

    Thanks in advance
    Regards
    Archana

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Looks like somebody created a table using "XXX_YY::TMP"; (ie. tablename in quotes) If it is OK, you can rename the table to XXX_YY. As to the significance of TMP, only the person who created it and maybe the almighty know it.
    mota

  3. #3
    Join Date
    Sep 2003
    Posts
    237
    Please ignore my previous post; db2 creates a table "xx::yy"; i am not able to create a table xx::yy.
    mota

Posting Permissions

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