Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations IDS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

AS400 and trying to autoincremenet the table

Thread starter techmanbd
Start date Dec 2, 2003

Status: Not open for further replies.

Dec 2, 2003

techmanbd

Electrical

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?

Brian
Manufacturing Engineer
Electro-Mechanical