how to add 10,000 records to new file with one field set equal to counter

["Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx>]

Title: how to add 10,000 records to new file with one field set equal to counter

Is there a simple way to add 10,000 records to a new file such that one field in the record is a counter as follows:

record#         fielda 
                contains
1               1
2               2
3               3
4               4
5               5

etc.

Can Query/400 do this?  Can SQL do this?  Or must I write an RPG pgm?

Thanks!