Re: How to number rows in SQL?

Posted in 2004

Serge Rielau — Wed, 21 Apr 2004 22:12:31 -0400 — source: Usenet: comp.databases.informix

I'd investigate writing a "counter" function that keeps state in memory and increments with every invocation. In DB2 it's called a SCRATCHPAD. Informix allows more memory tricks in routines so it should be possible to do the same thing. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab