Maintaining Audit Trails
The system maintains audit trail for all updates made to sequences using sequence maintenance routines. Each sequence has a separate set of audit entries.
For each updated sequence, the audit trail records original and final values. If the current value is the same as the original value, the system creates only one record.
Maintaining Sequences in Oracle
Normally, you use Database Sequence Initialization to set the starting sequence values in an Oracle database. The following information is provided if you need to manually maintain sequence values in Oracle, which cannot be done using Sequence Maintenance.
The standard sequence definition in Oracle is:
CREATE SEQUENCE <sequence name> START WITH <initial value>
INCREMENT BY 1 CACHE 75
Where <sequence name> is the same as defined in the Progress df and <initial value> is the starting value specified by the customer.
The initial value of a sequence is set to the highest value found in the field related to the sequence. The content of a sequence is the last value applied by a system function. See
Maintaining Sequences Manually.
Example: In a database with no user transaction processing, the maximum value of tr_hist.tr_trnbr is 1010. This value is used as the starting value of the sequence.
As user qad, you would enter the following SQL:
DROP SEQUENCE tr_sq01;
CREATE SEQUENCE tr_sq01 START WITH 1010 INCREMENT BY 1
CACHE 75;