Informix v Oracle

Posted in 2000

ASA GSI — Mon, 20 Nov 2000 10:30:52 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com

↪ replying to ASA GSI

Jonathan Leffler — Thu, 23 Nov 2000 00:34:21 GMT — source: Informix-list mailing list archive (1991-1998)

ASA GSI wrote: > Is there a function in Informix Dynamic Server 2000 that is like Oracles > CREATE SEQUENCE that uses NEXTVAL/CURVAL Not directly. The basic analog is the SERIAL column, but it does not work the same as a sequence. You can simulate sequences fairly effectively if you are careful. We had a fairly extensive email discussion about this internally a couple of weeks ago, some of it potentially useful. There are some tricky parts to it all. And IDS 2000 9.30 is supposed to have Oracle-style sequences in it. > and %ROWCOUNT, ect? What is %ROWCOUNT? ROWNUM I've heard of, but not %ROWCOUNT... What is "ect", etc? :-) -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"