|
Rob sez: If you are running V5R2, then abandon that technique and use a datatype of ROWID or identity columns to store your sequence number. http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst79.htm http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst80.htm All problems solved. create table rob/parent ::: remainder snipped ::: Neat. And we ARE on V5R2... but the other companies here at this client are on V5R1, so this won't cut it. We got the problem sorted; one of our guys had expereince implementing something he called 'optimistic locking'. I have no idea what that means. When I have a chance to look at his fix, I'll report back, if anyone wants to know... Thanks -Doc
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
