>Jim,
>
>I am looking for an easy way of committing all buffered table back to the disk. Can I use the old flush command to commit everything at once?
FLUSH will write data already committed to the file but possibly held in local storage; it will not do a TABLEUPDATE() or END TRANACTION to commit data held in buffers. You still have to TABLEUPDATE() on each view/table, and END TRANSACTION on any pending transactions, before FLUSH can force the physical write to take place.