Re: Next SERIAL Number in Online 9.3

On Mon, 12 May 2003 11:07:19 -0400, Dave Snyder wrote: Yes, why? IDS will tell you what serial value it actually DID assign the the last row you inserted in your current session. That is usually what one wants to know! The answer is that this is contained in the tables partition page header (sysptnhdr), but again, it's not a particularly useful value. It is likely to be outdated as soon as you fetch it unless the table is locked and locking the table will single thread your all of your users. Art S. Kagel > Is there a way to determine what the next SERIAL number that Online will > assign when someone does an INSERT into a table? > > Thanks!