Does RowNumber() work with AS400 V5R1 iSeries DB?

cws · #1 (**permalink**) 11-17-03, 18:53

Does RowNumber() work with AS400 V5R1 iSeries DB? I was trying to get a sequence number with each row during a select but it errors out saying that RowNumber() does not exist.

Thanks,
Chris

blom0344 · #2 (**permalink**) 11-18-03, 08:54

Nope, no such function for AS400. Aren't you confusing ROWNUM() function from ORACLE

There is a SQL reference for DB2 AS400: DB2_SQL_Ref.pdf

cws · #3 (**permalink**) 11-18-03, 08:58

I've seen other people talking about it for OLAP DB2 in this same forum, but not for AS400 iSeries.

Thanks,
Chris

Internet Services

Web Development

Digital Marketing

Consumer Tech