[progress Communities] [progress Openedge Abl] Forum Post: Need Help On Error: Failure...

  • Thread starter Thread starter Vel murugan
  • Start date Start date
Status
Not open for further replies.
V

Vel murugan

Guest
In my application I am trying to add a column to the table, I will be using the column as unique identifier to update the other columns of the table. In order to do that, i am locking the table in exclusive mode and then adding the new column UNIQ_ID. I am getting the below error while trying to alter the table. Update Query : LOCK TABLE PUB."customer" IN EXCLUSIVE MODE Update Query : ALTER TABLE PUB."customer" ADD (UNIQ_ID integer) java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Failure getting table lock on table PUB._File. what am I missing here?

Continue reading...
 
Status
Not open for further replies.
Back
Top