I am trying to alter the next value of a serial column.

I have the syntax as

ALTER TABLE timecard MODIFY (tindex serial (1000))

But this is not working.

We are on informix 7 using dbaccess

Anybody have any ideas?

Thanks

Do you want the next record to have a value of 1000 in the tindex column? Simply use 1000 during the next insert.