>Is there a way to run a SQL statement on buffered data that has not been committed on an optimistic table buffering with multi-locks on? The SQL is retrieving the original data from disk which is cool in some cases. In the past I've issued the 'COPY TO' then executed a select statement on the copy. Any suggestions would be appreciated.
I'm not sure if this will work, but try creating a view for your 'work' data with table buffering set and a second view with the first view as the source. When you are ready to do your selection, requery the second view then issue your SQL, something like...
SELECT * FROM view2 WHERE...
Let me know if this works.
//:^)