Yes this will work in Universe, we do it all the time. There are certain things that you can't have inside a transaction. Perform & input are the two that spring to mind. Also beware of where you do your reads. Reads inside a transaction get raised to a READU.... To get a full understanding of the effects of transaction boundaries write some small test programs. Have a look at the lock table while the programs are running. Move the reads inside and outside the transaction and see the effects.
Have fun. Les -----Original Message----- From: Bjvrn Eklund [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 09:54 To: '[EMAIL PROTECTED]' Subject: SV: [U2] Begin Transaction / Commit without turning on transactio n logging I have a follow up question.... What if you in program A use a BEGIN TRANSACTION and then start another program B and then come back to program A Like This: BEGIN TRANSACTION if x= 1 then call programB(y) end x=x + y + 1 COMMIT How does RFS handle this? Is the processing in program B a part of the transaction or? Bjvrn Eklund -----Ursprungligt meddelande----- Fren: Bob Witney [mailto:[EMAIL PROTECTED] Skickat: den 30 november 2004 10:29 Till: [EMAIL PROTECTED] Dmne: RE: [U2] Begin Transaction / Commit without turning on transaction logging This works fine, our main system has used it all the time since 1994 with absolutely no problems on Universe under AIX all releases Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dennis Bartlett Sent: 30 November 2004 09:04 To: [EMAIL PROTECTED] Subject: [U2] Begin Transaction / Commit without turning on transaction logging Hi All I've been told that using BEGIN TRANSACTION at the start of an update routine, and COMMIT at the end will cause the system to store (in memory) all pending updates until the commit... how true is this, and are there any caveats? --------------------------------------------------------- GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
