Im using Db2 Version 7.1. In my SP, i declared a Temp table like below
DECLARE GLOBAL TEMPORARY TABLE TABLE1
Item CHARACTER(30) DEFAULT '' ,
Name VARCHAR(50) DEFAULT ''
On my SP, first i delete this table( DROP TABLE SESSION.TABLE1;)
then create it, then Fill some data and Open Cursor to read the data from TABLE1, its working fine only.
Now the problem is, If 2 Users simultaneously accessing the SP, at this time User A data was sharing with User B. (Actually User A & B have different kind of data)
May i know how to avoid this kind of data sharing?