db2 sequence to reset automatically

#1

Hi,

Is there any way in db2 to reset the identity/sequence to reset
automatically after some period of time??

Eg:-
the ID format is <SEQ/IDENTY>/YYYY
(001/2010,,,,002/2010....901/2010...)
after one year i want the SEQ/IDENTY to start with 001 ie :
(001/2011..002/2011)..

Regards,
Ram

#2

On 6/29/2010 10:05 AM, Ramchandra wrote:

Quote:

Hi,

Is there any way in db2 to reset the identity/sequence to reset
automatically after some period of time??

Eg:-
the ID format is<SEQ/IDENTY>/YYYY
(001/2010,,,,002/2010....901/2010...)
after one year i want the SEQ/IDENTY to start with 001 ie :
(001/2011..002/2011)..
DB2 has scheduling capability. Just fire an ALTER SEQUENCE statement

from there.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

db2 sequence to reset automatically

comp.databases.ibm-db2 comp.databases.ibm-db2

db2 sequence to reset automatically - 06-29-2010 , 09:05 AM

Re: db2 sequence to reset automatically - 07-01-2010 , 08:09 AM