RE: How to reset the serial field once the max is reached?

The next serial number is stored in the sysmaster database for IDS 7.2 and IDS 7.3. It can be viewed with the oncheck command or via SQL: oncheck -pt <database>:<table> or SELECT serialv FROM sysptnhdr; -----Original Message----- From: Pachiano, Vince [mailto:pachiano@bassinc.com] Sent: Wednesday, March 10, 1999 12:35 To: informix-list@iiug.org Subject: How to reset the serial field once the max is reached? And while we are on the subject, where does Informix store the "next" available serial number? Or is it computed as needed? > -----Original Message----- > From: svedula8891@my-dejanews.com [SMTP:svedula8891@my-dejanews.com] > Posted At: Friday, March 05, 1999 11:36 AM > Posted To: informix > Conversation: How to reset the serial field once the max is reached? > Subject: How to reset the serial field once the max is reached? > > I have defined a field to be of serial type. The max (FYI) is > 2147483647. If > it reaches this max value, how can I resolve it? Will it be > automatically > reset to 1 or is there a way for me to reset it? Also, what happens > to the > purged serial numbers, i.e. if I delete some records over a period of > time, > will those numbers be reused once the max is reached? > > Any help will be greatly appreciated. > > Thanks > > Sharma > > -----------== Posted via Deja News, The Discussion Network > ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your > Own