Adding a serial column to a table.

I'd like to add a serial column to a large (10 million rows) table and I want the numbering to be as if it was always there (1-10,000,000) I can figure out how to do it with load and unload, but this takes forever. Is there a faster method using SQL / 4GL?