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

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.

Please ignore my previous post; db2 creates a table "xx::yy"; i am not able to create a table xx::yy.