At 01:50 AM 5/09/2003 +0000, you wrote:

>hi,
>
>I am having the above error code while I issueing a select query from
>isql:
>select count(*) from table1;
>
>it returns:
>Statement Failed, SQLCODE= -913
>deadlock
>
>
>What should I do to clear the deadlock? and what should I do to avoid
>this error happen again?

This is weird. It shouldn't happen at all in isolation levels SNAPSHOT or
READ COMMITTED. isql runs DML in SNAPSHOT by default. Writers in these
isolation levels don't block readers, so you should never get a lock
conflict just counting rows.

Can you provide some information about what database and version you are using?
What else was going on the database 1) inside your isql session 2) outside it?

heLen