Re: Next SERIAL Number in Online 9.3

Posted in 2003

John_Thomas@ao.uscourts.gov — Mon, 12 May 2003 11:40:51 -0400 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 00561CC985256D24_= Content-Type: text/plain; charset="us-ascii" select dbinfo ('sqlca.sqlerrd1') from systables where tabname ='xxxx' --John 202-502-2599 (or x 2599) dave@snide.com (Dave Snyder) Sent by: owner-informix-list@iiug.org 05/12/2003 11:07 AM Please respond to dave To: informix-list@iiug.org cc: Subject: Next SERIAL Number in Online 9.3 Is there a way to determine what the next SERIAL number that Online will assign when someone does an INSERT into a table? Thanks! --=_alternative 00561CC985256D24_= Content-Type: text/html; charset="us-ascii" select dbinfo ('sqlca.sqlerrd1') from systables where tabname ='xxxx' --John 202-502-2599 (or x 2599) <table width=100%> <tr valign=top> <td> <td>dave@snide.com (Dave Snyder) Sent by: owner-informix-list@iiug.org 05/12/2003 11:07 AM Please respond to dave <td>                To:        informix-list@iiug.org         cc:                 Subject:        Next SERIAL Number in Online 9.3</table> Is there a way to determine what the next SERIAL number that Online will assign when someone does an INSERT into a table? Thanks! --=_alternative 00561CC985256D24_=--