Problem:

Performance problems occuring due to locking issue.

Resolution:

1. Do not use the compiler directive  set(ansi92entry) with SQL Server 7.0

Using ansi92entry sets the transaction isolation level to serialization from the default of  read committed.  Add COMMIT statements to programs to release locks

2 .SET

exec sql set concurrency readonly end-exec

exec sql set scrolloption forward end-exec

immediately after connection or aternatively, just declare cursors to be forward and read only unless otherwise required, as in

exec sql declare x forward readonly cursor for ... end-exec

(note default concurrency is lock)