Hi,

Our product creates one table each every day to store data
for a specific day. The tables created have identical
columns. Whenever a new table is created, a view is created
that includes all the underlying tables. If the view is
queried from the interactive sql (dbisqlg)(select * from
eg_event_view) and the client is kept open accidentally or
unintentionally, we're unable to delete the view and create
fresh view that includes new table created. The view
deletion call just gets hung in the JDBC.

Is there a way by which in interactive sql some options can
be set so that, it does not created shared locks on the
tables/views that are queried.

Thanks,
Krishna

Hi Krishna,

DBISQL 11.0.0 includes an option to automatically release table locks. To
enable it, open the Options window, click "SQL Anywhere" in the left pane,
then check the "Automatically release database locks" box in the right pane.

-- Chris Irie
Sybase iAnywhere

<knazare (AT) bmc (DOT) com> wrote

Hi Chris,

Thank You for the information. We're using 9.0.2 version. Is
there a fix available on 9.0.2 version that addresses this
issue?

Regards,
Krishna