techmanbd Posted December 2, 2003 Posted December 2, 2003 I am trying to figure out how to auto increment a column that i basically make an ID that is an integer when a new record is inserted In Oracle I know you "Create Sequence ....". I tried that in the AS400 but I guess that is only a Oracle command and not standard SQL. Is there something like this on the as400 table? Quote Live as if you were to die tomorrow. Learn as if you were to live forever. Gandhi
fadi Posted December 3, 2003 Posted December 3, 2003 where do u want to set the auto increment? Quote
techmanbd Posted December 3, 2003 Author Posted December 3, 2003 I have a table called tblTestData and have a column called TestID and when I eneter the test data I want the TestID to auto increment Quote Live as if you were to die tomorrow. Learn as if you were to live forever. Gandhi
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.