SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-36
Considerations for ALTER TABLE
exceeded."
-- Value 3 exceeded MAXVALUE 2.
execute s1;
*** ERROR[8934] The MAXVALUE for the sequence generator has been
exceeded.
--- 0 row(s) inserted.
-- Note: The value from the third execute is lost since the execute
failed.
select * from T115T009;
id_KEY B C
------------- ----------- -----------
1 1 1
2 1 1
--- 2 row(s) selected.
-- Recover from the 8934 error by altering the MAXVALUE attribute of
the sequence generator.
alter table T115T009 alter column id_key set maxvalue 100;
--- SQL operation complete.
-- INSERT queries involving IDENTITY column are
-- non-retryable queries similar to INSERT queries
-- involving tables with indexes. So, open to the SG Table -- is blown
away and the query is not auto-recompiled.