Re: IDS to DB2 conversion

Serge Rielau wrote: > Barbara, > > 1. My boss is from Informix > 2. I spend a good deal of my time interacting with the Informix > developers who transfer technology into DB2. And how much time is spent transferring technology in the other direction...? -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche

Actually quite a bit. In 9.4 the sequence, the gls upgrades for unicode. In 9.5 there are several DB2 features that are being incorporated into IDS. Since 9.5 is not yet in beta, it's a bit too early to talk about specifics. But there are several DB2 features that are being put into IDS. However, the problems that have to be resolved with the DB2 product are significantly different than the things that need to be resolved in IDS. This is mainly due to the fundamental differences in the architecture and administration of the two products. M.P. "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bvjc7u$sgvai$2@ID-64669.news.uni-berlin.de... > Serge Rielau wrote: > > > Barbara, > > > > 1. My boss is from Informix > > 2. I spend a good deal of my time interacting with the Informix > > developers who transfer technology into DB2. > > And how much time is spent transferring technology in the other > direction...? > > -- > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche

Sequences, Instead of triggers. Both in IDS 9.4 I don't know about what's going on under the hood, but DB2's and IDS'/XPS' optimizers have very different strengths. A lot they can learn from each other. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab

Serge Rielau wrote: > Sequences, Instead of triggers. Both in IDS 9.4 > I don't know about what's going on under the hood, but DB2's and > IDS'/XPS' optimizers have very different strengths. A lot they can learn > from each other. Having seen some of what DB2's optimiser does, I'm not entirely convinced I'd like to see IDS or XPS learn from it. :o) Sequences are a minor goodness, although as a 20-year SERIAL veteran, I'm not entirely sure it is that much of a win. -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:<bvl055 ... > Sequences are a minor goodness, although as a 20-year SERIAL veteran, I'm > not entirely sure it is that much of a win. It isn't really. AFAICT It's just to be compatible with Orifice, who never got round to inventing simple things like SERIAL. Andy