Re: IUS: Datablades & portability

In article , Anders Karlsson wrote: > > Hi! > > REF types are in IUS, but not the full functionality and it's not yet > supported or documented. You CAN create a table with a REF but when you start to > use it, things gets weird. This is what the syntax looks like: > CREATE ROW TYPE foo(bar INTEGER); > CREATE TABLE foobar(foobar1 REF(foo));> > Note that this is the proposed SQL3 syntax. > > I tested this is 9.1. Anyone with a newer version out there that can test if > this works any better now... > > Karlsson Thanks for the clarification. This looks very much like a last minute decision by Informix to remove the feature from the documentation because it wasn't fully robust at 9.1. I would also be interested to discover whether anyone has tried it in a post-9.1 version. I described the feature in the evaluation of Universal Server in Ovum's recent report (based on the original 9.1 documentation) and it would be useful to know whether or not we need to issue an addendum to say that it has been removed from the documentation. I'm also following this up with Informix. (As the feature is a fairly limited implementation of pointers, its presence or absence doesn't actually affect our numerical scoring of Universal Server against its competitors). David Wells Ovum > adw@ovum.com wrote: > > My contacts at Informix tell me this Illustra feature didn't actually make > > it into Universal Server 9.1 (although the IUS 9.1 documentation I have > > suggest that it did - apparently erroneously and now corrected). > > > > The proposed IUS 9.1 reference type support was quite lightweight - based > > on Informix's serial datatype so not particularly fast and with REFs only > > unique within a table (cf. Oracle8's OIDs which can be globally unique > > and which can use a "hidden" row id in REFs for fast navigation). > > > > Full OID support was planned for IUS 9.2, but given recent events it > > wouldn't be too surprising if these plans were revised. > > > > > Nils.Myklebust@idg.no > > > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > > > My opinions are those of my company > > > The Informix FAQ is at http://www.iiug.org > > > > David Wells > > Ovum > > > > -------------------==== Posted via Deja News ====----------------------- > > http://www.dejanews.com/ Search, Read, Post to Usenet -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet