RE: Create View with a UNION ?

>Speaking of IIF2000, what is your opinion on the software? Seems very good, we had a problem with UC2 and are in the process of moving to UC4. Basically we could get the engine in an Assert fail loop >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? AFAIK IIF2000 = IDS2000 + web stuff + excalibur. >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? It definitely runs Solaris (2.5.1 to 2.8), we have IIF2000 and Solaris 2.7 on a production server - not a single problem (except the Assert problem mentioned earlier). On Linux all seems to be well. Other platformms I don't know You should be able to move from 7.31 to IDS2000 for nothing, I beleive it will be the normal charge later in the year. The move from 7.31 to IIF2000 is the price you would normally pay for the 731 to IDS2000 move "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

IDS2000 is based on 7.30-code so you don't have the extensions added in 7.31. IDS2000 do not have ANSI-joins, so you have to be careful. Tommi Mäkitalo