User ‘another user’ has the row in ‘ITSITI’ locked

Symptom

You are altering a table in the Sybase IQ but encountered with below error,

Could not execute statement.

User 'another user' has the row in 'ITSITI' locked
SQLCODE=-210, ODBC 3 State="40001"
Line 1, column 1

Solution

1. Check the lock status and connection ID.

sp_iqlocks

2. Once you get the connection ID from above command, execute below command to drop the user connection from the Syabase IQ database.

drop connection [CONNECTION-ID]