Re: Next SERIAL Number in Online 9.3

Posted in 2003

Jonathan Leffler — Tue, 13 May 2003 04:46:13 GMT — source: Usenet: comp.databases.informix

> dave@snide.com (Dave Snyder) asked: >> Is there a way to determine what the next SERIAL number that Online >> will assign when someone does an INSERT into a table? John_Thomas@ao.uscourts.gov wrote: > select dbinfo ('sqlca.sqlerrd1') from systables where tabname ='xxxx' That tells you the row that was assigned, not the one that will be assigned. There isn't any easy way to find out other than to insert a row and see - not least because of the concurrency issues if someone else is also trying it out. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/