The automatic numbering facility returns a series of integer values whenever data in the database is called. You can use this facility by defining a sequence generator. The automatic numbering facility helps you improve the efficiency of developing UAPs that perform numbering. It also helps improve portability from UAPs created using other DBMSs that support sequence generators. We recommend that you use the automatic numbering facility for numbering.

Organization of this section

4.19.1 About sequence generators

4.19.2 Defining a sequence generator

4.19.3 Deleting a sequence generator

4.19.4 Acquiring the sequence numbers generated by a sequence generator

4.19.5 Examples

4.19.6 Notes