Dan It's not clear what you mean about "validating" the view. When you CREATE a view, it should be instantaneous - all you're doing it putting a row in the SYS_VIEWS table.
When you SELECT from the view, R:Base processes the SELECT command under the view, no more, no less. It seems you are saying the views work fine at the R> prompt, but not in the code? What precisely is the point in your code - please post it - where the time delay occurs? David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Dan Goldberg" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, March 19, 2005 1:00 PM Subject: [RBG7-L] - Turning off verifications when creating a view > I have programmed in some command files to create some complex views. > > create temporary view tmpviewname as select.... > > When I run the command file it takes a long time to validate the views. I > have already have tested them and they work fine. > > Does anybody know of a way to turn off the validation when creating views?? > This would speed the command files up tremendously. > > Dan Goldberg > >
