BEGIN/COMMIT work in Stored Procedure

Posted in 1998

Fred Prose — Tue, 6 Oct 1998 13:54:42 -0700 — source: Informix-list mailing list archive (1991-1998)

What is the prevailing thought about using BEGIN/COMMIT WORK within a Stored Procedure? I've got a SP which is called to obtain and increment a "next serial number" column. This potentially will cause a bottle nexk and I'd like to have the SP "get in and get out" ASAP. Any other suggestions to make sure the SP isn't doing any dirty reads? Thanks,