My application is used by multiple users.I have used global temporary table in 2 queries which are constantly used by multiple users. The name of the table on both the queries are SESSION.TEST. My query is:
1. Do i have to use 2 table name for the 2 query called as SESSION.TEST1 for 1st query and SESSION.TEST2 for 2nd query.
2. Do i have to provide an explicit DROP statement as i am receiving error in db2diag file: a cursor is still open?