Rowid In Db2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • arivudai2
    New Member
    • Dec 2006
    • 2

    Rowid In Db2

    Hello,

    I am doing a migration of db from informix to db2.In informix there is a query with rowid.The same query with rowid is not working for DB2.Can anyone help me in this regard.
    for Ex.

    In Informix,

    select rowid from tablename or
    select * from tablename where rowid = 225

    I want equivalent queries in DB2.

    Its very urgent.....
  • yrayanki
    New Member
    • Nov 2006
    • 6

    #2
    Originally posted by arivudai2
    Hello,

    I am doing a migration of db from informix to db2.In informix there is a query with rowid.The same query with rowid is not working for DB2.Can anyone help me in this regard.
    for Ex.

    In Informix,

    select rowid from tablename or
    select * from tablename where rowid = 225

    I want equivalent queries in DB2.

    Its very urgent.....

    We don't have the concept of ROWID in DB2 UDB for LUW .

    Comment

    • arivudai2
      New Member
      • Dec 2006
      • 2

      #3
      Originally posted by yrayanki
      We don't have the concept of ROWID in DB2 UDB for LUW .
      if it is so.. how can i handle this scenario..

      Comment

      Working...