Create sequence from informix which version

meiwen · #1 (**permalink**) 06-07-06, 03:27

Hi,
Anybody has idea that 'create sequence' this function is from informix which version? V9_4 or V9_3 ?
More precisely, Does Informix 9.30.UC2 has create sequence this function ?

thanks to reply me.

anders5737 · #2 (**permalink**) 06-07-06, 14:18

Release notes for 9.40 indicates it was introduced in that particular release.

http://www-306.ibm.com/software/data...s/C170116.html

Quote:

8. Sequence Objects
This release introduces new DML statements (CREATE SEQUENCE, ALTER SEQUENCE, RENAME SEQUENCE, DROP SEQUENCE) for sequence generators, database objects that multiple users can access concurrently to generate unique integers in the INT8 range.

I have not confirmed this myself...

meiwen · #3 (**permalink**) 06-08-06, 08:07

It is not in 9.3, i tried it.

Internet Services

Web Development

Digital Marketing

Consumer Tech