On 18/05/2017 08:29, Abhirama wrote:
Hello,
I am facing 40XL1 error when I try to insert rows into a table with an
identity column. Identity column has been created using "id integer
generated by default as identity (START WITH 100, INCREMENT BY 1)". This
is also the primary key for the table. Start with 100 is used because I
use 1 to 99 range to insert deterministic values for test cases.
Usual reason is some other query has a lock on the table -- maybe you
did a SELECT involving that table and forgot to close the ResultSet?
--
John English
