Additional Sequences
If you want to create an additional sequence and are using an Oracle database, you can either model the new sequence class as an implementation of the wt.fc.DatastoreSequence interface or you can add the sequence to the Oracle database using the following exec command format:
exec wtpk.createSequence('seq_name',start_num,inc_value)
where:
• seq_name is the name of the new sequence.
• start_num is the first number used in the numbering sequence.
• inc_value is the number used to increment the sequence.
For example, if the new sequence is named my_seq and the sequence starts at 100 and increments by 5, then the exec command is:
exec wtpk.createSequence('my_seq',100,5)
If you want to create an additional sequence and are using an SQL Server database, you must model the new sequence class as an implementation of the wt.fc.DatastoreSequence interface.
For information on modeling a sequence class, see
Persistence Datastore Sequence Customization.