Hi David.

These files are views of data in various formats, like a Datewarehouse of Invoices for the year, but one set would be By Customer, another by Customer within product within Group, another by Rep By customer etc.

The content od the files , and indeed their structure etc is governed by parameter files set by the user and generated overnight.. so they dont lend tjemselves to views easily.

Regards,

Gerard


>Gerard,
>
>What requires you to regen these exactly? Can they be parameterized views instead?
>
>>I'll have a go at your suggeation.. my only concern is that some of the tables can be quite large (They are only used in these forms for enquiry purposes) and creating a cursor intoduces another overhead.