Db2 Tools for zOS

 View Only
Expand all | Collapse all

Row_Number function in DVM

  • 1.  Row_Number function in DVM

    Posted Thu April 22, 2021 12:39 PM
    Hi All,

    Does DVM supports Row_number() and partitioning the result sets? I tried adding row number and it keeps returning me the error that "Invalid token ROW_NUMBER found preceeding left parenthesis". 

    I couldn't find any reference to it in DVM manual too. 


    ------------------------------
    Thanks
    Prasanna
    ------------------------------

    #Db2Toolsforz/OS


  • 2.  RE: Row_Number function in DVM

    Posted Thu April 22, 2021 03:44 PM

    Hello Prasann,

    DVM doesn't currently support the row_number() function. Are you attempting to connect to a SQL Server using that syntax with partition? 

    IBM is currently investing to support this and other SQL 99 functions for DVM.



    ------------------------------
    Doug Dailey
    ------------------------------