Carol :
>> One of several databases has one table with an autonum column that sometimes skips 30 or 40 numbers, apparently overnight. The column definition is 8 characters, with a format of 00000000 and increment of 1. The current initial value is 4306. It is a primary key. It is used as a record number. We run a packing procedure automatically every night using reload. Any ideas on what may be happening? << I also do have some problems with AUTOMUN columns. So, after every BACKUP, UNLOAD/RELOAD DB, I insert : SET rules OFF AUTONUM ColumnName IN TableName USING 1 NUM SET rules ON If you use rules, don't forget to set RULES OFF. If you don't, and if somes rows contains bad data, AUTONUM will stop and you may have duplicate values in ColumnName ... Hope this will help ... J.M. GRATIAS, Logimatique, France
