Trouble Droping Temp Table
Posted in 1997
Hi, We have a Power Builder application to generate reports. We have one user id to login to PB (and then to Informix). So, two people (P1 and P2) can login into the same application and run the same report. In generating this report we do the following: 1. genereate temp table A,B,C with no log; 2. Insert into A,B, and C. 3. Drop table A,B, and C Everything is done in that order. Problem: If only P1 starts the application (using user_id above) and we have no problems. Then P2 logs in (with same user id as P1) and that's it ..Temp tables are locked and cannot drop them. We get SQL error of -242. Amazing thing is that no matter how many users run this application, all temp tables generated are all Unique. No two temp tables have the same name at any given name No matter how many users log in (They must all use the same user id to start though!). Thanks in advance for your help. Keith