Announcement

Collapse
No announcement yet.

orcale -> db2 query question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • orcale -> db2 query question

    Hello,

    A quick question of the DB guru's here...

    What is the equivalent in db2 (iseries) for the sql command:
    Code:
    first_value(s.a) over(partition by s.b, s.c order by s.b) as start_loc
    (part of the select statement of a query)
    Error message occurs at the first_value...

    Thanks!


    Jörg
    pixar
    Dream as if you'll live forever. Live as if you'll die tomorrow. (James Dean)
Working...
X