The whole point of using transactions is to ensure data integrity. Writing across a network is a pretty sure-fire way of inviting integrity problems.
The only way to guarantee that you don't have problems is to ban mixing the two. If you investigate the NFS protocol (which I guess your remote system is using?) you will find that it explicitly guarantees that the integrity of the link CANNOT be trusted. Now I think you see why transactions forbid its use ... Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: 04 March 2004 03:08 To: U2-users Subject: UniVerse 10 :Network writes not allowed within a transacton. Dear U2 Users, Is anyone having idea regarding the uniVerse 10 when apply the Begin/End Transaction, it do not allow to write to the remote file. Once execute the program , it prompt the belowing messages Network writes not allowed within a transacton. Is it the security of the Database ? For eg , From Server A , having a program as below to access the remote file of Server B ( ie ASY.FV ) which is code within the Begin / End Transaction ... READU REC FROM ASY.FV , ID ELSE CRT "ERROR READ FILE" EXIT BEGIN TRANSACTION REC<1> = "TEST" : X WRITE REC TO ASY.FV,ID ELSE CRT "FAIL WRITE REC" END IF ( P.ERROR ) THEN ROLLBACK END COMMIT END TRANSACTION RELEASE ASY.FV Error message is as follow FATAL: Network writes not allowed within a transacton. rolling back uncommitted transactions begun within this execution environment. Thanks and Regards DISCLAIMER:- <<This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you.>> -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *********************************************************************************** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *********************************************************************************** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
