Re: Create View with a UNION ?

Hi Art. Speaking of IIF2000, what is your opinion on the software? I purchased the $199 IIF2000 on Linux thing and played around with it, and it looks pretty good. The java Krakatoa thing and the time series datablade are what I'm really interested in. (Although there is no time series datablade on Linux just yet). What exactly is the diff between IDS2000 and IIF2000? Should I upgrade from 7.31.UC2 to IDS2000/IIF2000 just on general principle? Someone said I have till August to upgrade. Not a lot has been mentioned here on CDI about IIF2000. Has it only been ported to certain platforms? (I use HP-UX 10.20). Should I jump over? Any thoughts appreciated. PS-Hope your leg is healing up quickly. Nice to have you back. Allen "Art S. Kagel & Family" wrote: > > Mark D. Stock wrote: > > > > Doug Agnew wrote: > > > > > > Well, > > > > > > That select can be implemented WITHOUT a union, so it may be the optimizer > > > is allowing it. > > > > The syntax of the CREATE VIEW command has nothing to do with the > > optimiser! That only kicks in when you run it. > > > > > SELECT tabid from systables Where tabid >50 or tabid<99> > > > > > is equivalent. > > > > It was an example of UNION syntax, which passed. > > > > > And, that is equivalent to : > > > SELECT tabid from systables.> > > > But that doesn't test the UNION syntax. > > > > UNION in a view was only introduced recently. Someone said 7.30, I think > > it was actually earlier. > > IDS 7.24 does not allow UNION in VIEWS. UNIONS in VIEWS are a 7.30+ > feature and so is also included in 9.2x (IDS/IFF.2000). > -- > Art S. Kagel & Family > kagel@erols.com