"set current schema" and commit 
Author Message
 "set current schema" and commit
Quick question, if one does a "set current schema", should a commit
follow after this statement or not?

Thanks.



Sun, 28 Nov 2004 00:09:53 GMT
 "set current schema" and commit

Nope, in fact, to the best of my knwoledge setting special registers is
non transactional. (Coudl be tested easily enough).

Cheers
Serge
--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada



Sun, 28 Nov 2004 00:42:42 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Set schema="yourdb"

2. Set schema="yourdb"

3. max of ("...","...","..")

4. JDBC isolation level "read committed"

5. Need a sample of "commit".

6. Looking for "auto commit count" feature

7. "Broadcast on commit"

8. Segmentation violation in "COMMIT WORK"

9. Empty "Current Activity" Window

10. "Current Activities" in E.M. doesnt work

11. Cannot drop table "CURRENT"

12. Viewing "Current Acitivity"


 
Powered by phpBB® Forum Software