I am running a customised session. For logic purpose i have created a temporary table which is getting cleared at the end of the session.

While executing the session the table is inserted or updated and at end the table is cleared using "db.clear.table"

A lock is created on the table while running the session and is not removed.

I created another table with same structure as i was unable to remove the lock on the table.

But even after creating a new table the problem persist.

Can anybody suggest any changes in the script attached ????

function db.clear.table should be followed by commit.transaction()

I am running a customised session. For logic purpose i have created a temporary table which is getting cleared at the end of the session.

While executing the session the table is inserted or updated and at end the table is cleared using "db.clear.table"

A lock is created on the table while running the session and is not removed.

I created another table with same structure as i was unable to remove the lock on the table.

But even after creating a new table the problem persist.

Can anybody suggest any changes in the script attached ????

Hello,

why not at beginning ?
In:
before.program:

Regards