Extending DB Sequence

You cannot modify any application-provided database sequence. But, allowed to modify any application-provided tables. You can also create a table and modify it in multiple iterations. However, you can create only a database sequence, but cannot modify the sequence.

Unlike database tables, you cannot manage or own a custom database sequence. If you need a change in the sequence that you created, log a ticket with IBM Support, or discard the sequence and create a new one. If you choose to create a new one, then you must also change your code to use the new sequence name.

When you work with database sequence, avoid the use of direct SQLs to get the sequence number. Instead, call the com.yantra.shared.ycp.YFSContext.getNextDBSeqNo(<sequence name>) method to get the next database sequence.