Hello everyone,
When we use create view statements on our progress sql server it seems to create an exclusive lock on the PUB._File table. This makes perfect sense because the data dictionary must be updated for the new view. The problem is we can figure out a good way to release this lock after the drop and create view statments are finished. So far the only choice is to exit the query tool (DbVisualizer) completely and that seems to release it. With the lock in place on this table we cannot even connect to the database from our application so it will be very disruptive.
Does anyone know a better way to do this? Maybe with sqlexp we could send the right command to release the exclusive lock.
Thanks,
Matthew