Hi,i want to know that,Will the functionality of these two statements:EXEC SQL SET TRANSACTION READ ONLY END-EXECEXEC SQL SET TRANSACTION READ WRITE END-EXECare same as “EXEC SQL SET TRANSACTION REPEATABLE READ END-EXEC”Give me the replacement for the above 2 sql statements.thanks in advance,rashmi

  • Interview Candidate
  • 3
  • 2547

Showing Answers 1 - 3 of 3 Answers

ramkiibm.yerra

  • Aug 29th, 2007
 

Hai Rashmi?
Its not Similar. The First statement is only for Read-Only Trasactions that to be used in PL/SQL Block. The Second one is for Isolation Levels like Read Uncommitted, Read Committed, Repeatable Read, Serializable.

Regds
Rama Krisha.Y
ramakrishna . yerra @ in . ibm . com

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions