SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-30
Considerations for ALTER TABLE
--- Retry happens on the subsequent execute that raises
--- *** ERROR[8574] An OPEN was blown away on SG_table.
execute s1;
*** ERROR[8574] An OPEN was blown away on table
CAT.S15."@@INTERNAL_SG_511312700289154_@@".
*** ERROR[8935] The sequence generator update failed, see additional
diagnostics for failure details.
--- 0 row(s) inserted.
-- The above error occurs on the access to the SG Table,
-- hence the CURRENT_VALUE in the SG Table is not updated.
select * from T115T009;
ID_KEY B C
---------- ---------- -----------
1 1 1
2 1 1
--- 2 row(s) selected.
-- This is a non-retriable query, hence execute command –
-- must be re-issued.
-- The query is recompiled and the following warning is
-- raised "*** WARNING[8576] Statement was recompiled"
--
execute s1;
*** WARNING[8576] Statement was recompiled.
--- 1 row(s) inserted.
-- Notice the value 3 is missing from the ID_KEY value.
-- It was lost during the
-- execute that failed with " *** ERROR[8934] The MAXVALUE
-- for the sequence generator has been exceeded."
select * from T115T009;
ID_KEY B C
------------- ----------- -----------
1 1 1
2 1 1
4 1 1
--- 3 row(s) selected.