What does the below Insert statement do
I mean whats the Improtance of ::TMP here???
INSERT INTO XXX_YYY :: TMP
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.
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.