> > wants to create MV's out of them so that "WebFocus will behave as expected" > > I'm not familiar with WebFocus but have seen some tools using an ODBC connection throw an error if a query doesn't return data within a timeout period. It might be that he wants to create MVs to avoid that timeout. Another approach would, of course, be to lengthen the timeout. -- Rumpi Gravenstein