On the storage process 1 version 7.2, the cursor can build indexes that if the comparison table, or several million, and another one million level for the formal table related data will be relatively slow and what the solution? 2 storage business is how to control the process? Is a storage process is a matter? Can be stored inside the building Affairs increase sentences begin work? Storage course of the following three sentences : Create procedure p () Language sgl Begin Declare global temporary table session.sess_1 (PGA int) on commit preserve rows not logged in TEMPSPACE1; To insert into session.sess_1 values ( 'lkk'); End @ Call p;insert words fail, but to create the temporary table session.sess_1 not deleted, how to control the call automatically deleted after the failure to create the temporary table. Thank you very much counterparts On the storage process 1. I do not know if it is not possible to build 720 Index, 8.1 temporary table but also can be used to build the index. 2. Services are set by your own, you can complete an operation on COMMIT that such a submission affairs. 3.col is INT型, you insert the string is, of course, not inserted into the Provisional connecting calls on their table is if you delete the last you add DISCONNECT ALL . On the storage process One can build 720 index of 8.1 is the 3 End Storage implementation process of performing disconnect current, but if memory error in the implementation process, it will not disconnect current implementation, it will not delete the temporary table, then another storage implementation process, if there is the same as the provisional table, the storage process will be reported in the erroneous form has been temporary, The language adopted in the creation of temporary table topped with replace solution. There would have been covered by the temporary table. declare global temporary table session.sess_1 (PGA int) with replace commit preserve rows on not logged in TEMPSPACE1. [ Closed window ]