All Forums Database
sps1 9 posts Joined 01/15
30 Apr 2015
Parellal insert statement against same global temporary table

Hi Gurus,  I have three scripts running in parellal and each of them using INSERT statement to same global temp table. Can it cause any issue? Thanks for your help. 

dnoeth 4628 posts Joined 11/04
01 May 2015

No, because every session uses it's own version of that table.
Do you finally Insert/Select into a permanent target table?

Dieter

sps1 9 posts Joined 01/15
01 May 2015

Got it! Thank you. Yes, I am loading data to permenant target table at end of my script.

You must sign in to leave a comment.