Why does Altering the INCREMENT BY clause of a Sequence object cause the analysis to generate a DROP/CREATE instead of an ALTER?

Document ID : KB000022692
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Why does Altering the INCREMENT BY clause of a Sequence object cause the analysis to generate a DROP/CREATE instead of an ALTER?

Answer:

Creating an Alter strategy to modify the INCREMENT BY parameter of a Sequence object generated a DROP/CREATE on the object and not an ALTER statement. In this strategy Global Changes were used with a change specified for CODE SQSC which is the Sequence Object Schema.

When there is a Global Change applied to the Sequence Object via the Global Change SQSC (Sequence Schema), this forces the DROP/CREATE of the Sequence Object because the schema is changing.

When the Alter is used to only change the INCREMENT BY clause without a SQSC Global change, an ALTER statement is generated in the analysis output.