We have developed a large PHP application using adodb-4.22, php-4.2.2 and IBM DB2 v8.2 and saw that simple select statements in our code like Execute('select * from sesys.role order by role_id') place unwanted exclusive locks on the table referenced in the SQL
I need to UPDATE or DELETE a view (query) that is on the server But the UPDATE needs to be made to the CODE of the view and not to the data it returns. Please help