Hi Group,

I'm using ESQL ( DB2 in C program ). I've set the isolation level as UR while binding .sqc file, But the locks remains on the DB and never get released. Is there any way to come out of this problem.

Also while surfing the net I came across WITH clause in the SELECT statement. Will this solve my problem.

Waiting for the reply..