Sequence Number Generator in IDS 9.4

Anyone using or familiar with this new feature in IDS 9.4? We are wondering what it would take to convert from IDS 7.3 to 9.4 and implement this feature. How would serial numbers be converted to sequence numbers? Is there a utility to do this? Thanks for any input!

Cindy Lichtenauer wrote: > Anyone using or familiar with this new feature in IDS 9.4? > > We are wondering what it would take to convert from IDS 7.3 to 9.4 > and implement this feature. How would serial numbers be converted > to sequence numbers? Is there a utility to do this? SERIAL columns still work just as they always did - no problem, no change. Consequently, there's no utility to do it. (If you really want one, run: cp /bin/true $INFORMIXDIR/bin/upgrade.serials-9.40 as root and then run upgrade.serials-9.40 -- it's fast!) So, now it is up to you what you do with your application. The easiest thing is to leave it using serials. If you choose to modify it to use sequences, so be it - RTF(abulous)M and have fun. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/