Re: IDS to DB2 conversion

Jerry, Every DB2 site that is using DB2 replication(DPROP) to replicate DB2 to/from IDS, Oracle, Sybase, msSQL, etc. is either using datajoiner and/or federated. Datajoiner is basically the pre-cursor to federated. So there really are quite a few shops that are using federated. M.P. "Hamilton, Jerry" <hamiltoj@fleishman.com> wrote in message news:bvodn8$dab$1@terabinaries.xmission.com... > > Federated!?!? I tried to convince our company to run a piece of our > reporting structure against Federated... They laughed. Who's using > Federated??? > > -----Original Message----- > From: Serge Rielau [mailto:srielau@ca.eye-be-em.com] > Sent: Tuesday, February 03, 2004 7:12 AM > To: informix-list@iiug.org > Subject: Re: IDS to DB2 conversion > > > Federation for example? Need in the middleware layer? > Also this is the principle of bang-for-the-buck. > I can tell you first hand that sequences and serial/identity are nearly > identical under the hood. But one gives more options than the other. > Personally I'm a fan of RISC. Use the least number of features that > yield the most function. > Sequence + before trigger = serial/identity > How do you go from a serial/identity to a sequence? > A major ISV asked us this question a few years back. I couldn't come up > with a good answer. Best I could propose was to use a table with serial > and keep inserting into it. Then garbage collect on occassion. Got a better > idea? > > Cheers > Serge > -- > Serge Rielau > DB2 SQL Compiler Development > IBM Toronto Lab > sending to informix-list