I want delete a table with references with

error.bypass = 1
ret = db.drop.table(ttiitm001,DB.IGNORE.ALL.REFS)
commit.transaction()

but the table don't delete.

Whow can I do it?

Thanks

We use a commit also before the drop.table.

But nobody has to use the table while you are running the session. With informix we had some problems, now with Oracle, it works better.

Regards

Thanks Richard, but the table don`t drop

I'm not sure that you want to just turf those records ... try removing the references by using ttaad4229m000 'print references to parent'. This will surely work.

Have you tried a seqential dump (session ttaad4226m000) and check the box Drop Table after Dump?