RE: IDS to DB2 conversion

Posted in 2004

Hamilton, Jerry — Tue, 3 Feb 2004 09:07:54 -0600 — source: Usenet: comp.databases.informix

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