Re: two questions

Posted in 1999

Obnoxio The Clown — Mon, 01 Nov 1999 11:48:56 GMT — source: Informix-list mailing list archive (1991-1998)

From: Yirmiyahu Fischer <yfischer@vanenburg.com> > >1. According to the documentation on the internet a union is supposed to >be >legal inside a view. >In practice, on my Informix 7.23 database, I get a syntax error. >Am I missing a trick? No, just an upgrade. (To 7.31, probably! :-) >2. Is there a way of creating or updating a view for an Informix database >that will be legal >whether the view previously exists? >(For Oracle databases, the command is CREATE OR REPLACE FORCE VIEW) Nope. Best bet is to try to drop the view as part of the process. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com