Unanswered: To reseed identity column value starting from 1 evary day..
I am using IBM data studio z/OS 10.
I have one requirement like,in a table there is one identity column created.
For the first day 1000 records inserted into the table and the identity column value started from 1 to 1000 but next day while records got inserted then the identity column value SHOULD NOT start with 1001,it should again start from 1 onwards.that means evary day identity column value should start from 1 onwards.
Can anyone please suggest me how i can achive this?