i created a table in db2 control center. one field is called userID and it's a integer data type. userID is a primary key. is that possible to set this field automatically increased by 1?
what i want to do is in a jsp page, there is an interface for adding user. after click the submit button, the user's info should be added into the database, the id field value should be increased by 1
in mysql, this function is available.
thanks very much for your reply,