Progress
Programming
Handbook
Creating and Maintaining Sequences
You can create and maintain sequence definitions in a database using Progress’s Data Dictionary. Progress stores all sequence values together in a single database block, and stores sequence names and their remaining attributes in a metaschema table named _Sequence.
For information on defining, editing, or deleting sequences in your database, see the Progress Basic Development Tools (Character only) manual and, in graphical interfaces, the on-line help for the Progress Data Dictionary.
For information on using sequences in the 4GL, see the "Accessing and Incrementing Sequences" section in this chapter.
Providing Sequence Security
You can restrict sequence access by assigning user privileges to the _Sequence metaschema table. The Can–Read privilege grants users permission to read the current value of a sequence with the CURRENT–VALUE function or to increment and read the next value of the sequence with the NEXT–VALUE function. The Can–Write privilege grants users permission to change the current value of a sequence with the CURRENT–VALUE statement. Any user privileges assigned to the _Sequence metaschema table apply to all sequences defined in the database.
For more information on providing security to a database table, see the Progress Database Administration Guide and Reference.
Dumping and Loading Sequences
You can dump and load sequence definitions and values using the Database Administration tool. Select the Database Administration item from the Tools menu of the ADE Desktop. For more information on dumping and loading sequences, see the Progress Database Administration Guide and Reference.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |