Initializing Sequences
Database Sequence Initialization reads each table that uses sequences and sets the sequence number value to the highest number plus 1. This ensures that each new record created has a unique number. This utility initializes sequences correctly in both Progress and Oracle databases.
Database Sequence Initialization (36.16.17)
Maintaining Sequences Manually
Maintain sequences manually or through the CIM interface. Maintenance includes:
• Dumping—outputting the current sequence value to a file
• Loading—reading a sequence value from a file
• Updating—manually updating a single sequence
Maintain sequences in Sequence Maintenance (36.16.13). Sequence Maintenance works with Progress Relational Database Management System (RDBMS) only. Oracle dataservers are not currently supported.
Log File Name
The name of the error log file.
Directory
The operating system (OS) directory where you want to store the file.
After you enter the log file name and directory and click Next, a second Sequence Maintenance frame displays. Enter data for the following fields in this frame:
Sequence Name
Specify the sequence or set of sequences to be maintained. Leave blank to specify all sequences.
Note: A time stamp is added to the log at the beginning of each session, so session history can accumulate. After a maintenance session, check the log for errors.
Maintenance Activity
Specify the maintenance activity to be applied to the specified sequence sets. Valid values are:
• 1 to dump. Outputs the current sequence value to an OS file.
• 2 to load. Reads the sequence value from the OS file.
• 3 to manually update. This activity can only be performed when a single sequence is specified. When a set of sequences is to be manually updated, the manual update activity is called once for each.
Activity Directory
For a dump or load, specify the OS directory where the sequence files are located. The direction of the data flow is determined by the activity.
Files are named using the name of the sequence with the file extension .d. For example, the sequence tr_sq01 is dumped to a file named tr_sq01.d.
When you specify manual update, the system displays the Manual Update frame. Specify the following in the frame:
Original Sequence Value
This field displays the value of the sequence before the user’s update was applied.
Current Sequence Value
This field displays the current sequence value.
Note: Sequence Maintenance generates a report listing current values of all sequences in the database. It can be run at any time and does not impact the content of sequence structures.
User Input
Enter any sequence value within the valid range. The valid range is determined by the system and is part of the schema. An error displays when the value entered is not within the valid range.
