Re: auto increment in select clause

In DB2 you can use

SELECT ROW_NUMBER() OVER(), ref FROM table

or

SELECT NEXVAL FOR sequence FROM table

the former is more flexable as you can PARTITION and/or ORDER your sequences

TTM suggests a TAG operator in RM VSS #1 which would work somewhat like ROW_NUMBER Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Wed Jun 12 2002 - 16:57:53 CDT