[IUG] Record numbering

["West, Barbara - HPL" <Barbara dot West at cityofhouston dot net>]

Can someone tell me what happens to record numbering when a system reaches
record number 99999999 of any given type?

We "think" -- but I have not been able to confirm in the manual or FAQ's --
that numbering starts over, with an algorithm preventing the creation of
duplicate record numbers.  In our case, we believe numbering would begin
over with 91...... ; the last order record in the system at this writing is
o99058054  and the last item is i99372745.

Has anyone gotten to the point in their numbering scheme to observe what
happens?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Barbara F. West, Assistant Database Administrator
Houston Area Automated Library Network (HALAN)
500 McKinney Ave. Suite 300
Houston, TX 77002-5000

Phone:   832-393-1410
Fax:     832-393-1427
E-Mail:  Barbara dot West at cityofhouston dot net
 
If you would like to receive periodic emails from Mayor Bill White and the
City of Houston on topics of interest to you and your neighborhood, please
go to www.houstontx.gov <http://www.houstontx.gov>  and register with
CitizensNet.




--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---