OK, but it is more common to define the column as int so that you can easily handle the number.If the datatype for that column was defined as FIXED(38) IMHO the serial value may be 10^38 . That should be enough for most purposes ;-)
I think the Serial wraps around to 1 again. That makes a max-number of 2^31 record (without negative numbers) in a table.
The problem is, that a serial is just growing - and it's not really a problem, because it's the only way to gurantee the the last serial value is a good identifier for a long time!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
