Topic
  • No replies
winseelan
winseelan
2 Posts

Pinned topic Temp Table in Db2 Version 7.1

‏2013-09-17T12:03:13Z |

HI all,

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?

Updated on 2013-09-17T12:03:43Z at 2013-09-17T12:03:43Z by winseelan