Why does Altering the INCREMENT BY clause of a Sequence object cause the analysis to generate a DROP/CREATE instead of an ALTER?
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.