>I have a problem deleting index file.
>
>I use command INDEX ON someExpr TO temp.idx on one table in one work area.
>
>I open same table in another work area and when I want to delete temp.idx it says that file is in use and I cannot delete that index.
>
>How to delete that index file because BEGIN TRANSACTION command is requiring that?

When you open the same table in another work area, the index file "goes along", the same goes for filters and other attrributes, like for instance exclusive/shared, and noupdate. So you either must wait, and delete the idx later, or you must close the table, delete the idx, and then reopen the table.