Justin-

< snip>

>>>Has anyone else seen this behaviour? Is there a limit to the number of RVs a DBC can handle?

>>Since you haven't had any other replies...I can't find any reference to a physical limitation, although I do think there's a practical one, from the point of view of performance. I tried the following example code. It worked well enough, although I stopped it after 7,932 views were added. MODI DATA isn't advisable at this point and even SET DATA TO took a few seconds

< snip>

>Well we are nowhere near that many - about 750 or so. But that does answer my question about size limitations - if you were able to add 7,932 views then we are not hitting any physical limit...

I was afraid of that. So, the behavior is something else. Can you pinpoint when it happens? Any code anywhere that does a DROP VIEW? Anybody accessing the database from another app? Any chance you have a naming algorithm that might not be working quite right? That last one is a stretch. Well, all of the questions are, I guess. :-\