Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    8

    Unanswered: Does RowNumber() work with AS400 V5R1 iSeries DB?

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    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
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    Feb 2003
    Posts
    8
    I've seen other people talking about it for OLAP DB2 in this same forum, but not for AS400 iSeries.

    Thanks,
    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •