I am retrofitting an application which today looks something like this...

BEGIN TRANSACTION

READU REC FROM F.FILE, ITEM.ID THEN

        REC = DATE()

        WRITE REC ON F.FILE, ITEM.ID THEN

                COMMIT

        END ELSE

                RELEASE

        END

END ELSE

        ROLLBACK

END

END TRANSACTION


Changes require the lock be acquired prior to the BEGIN TRANSACTION...

READU REC FROM F.FILE, ITEM.ID  THEN

        BEGIN TRANSACTION

        REC = DATE()

        WRITE REC ON F.FILE, ITEM.ID THEN

                COMMIT

        END ELSE

                ROLLBACK

        END

        END TRANSACTION

END ELSE

        RELEASE F.FILE, ITEM.ID

END

Are there any negative consequences of doing so?

Thanks.

Perry Taylor
Zirmed, Inc.


Perry Taylor
Office (877) 494-7633 ext. 4392
Direct (502) 779-4392
Zirmed, Inc.
626 West Main St., 6th Floor
Louisville, KY 40202
www.zirmed.com

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health Information,
any communications containing such material will be returned to the
originating party with such advisement noted. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies of
the original message.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to