Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: any words in DB2 same as Orcale ROWNUM or ROWID

    Dear All,

    I am using AS400 V5R1 DB2, I have encountered a problem that I can no identy the row which I selected.

    does the DB2 has any word like ROWNUM, ROWID, Record No, etc.

    Thanks

  2. #2
    Join Date
    Aug 2004
    Posts
    5
    I am using V5R3 and db2 does have a rowid data type.

  3. #3
    Join Date
    Sep 2004
    Posts
    2
    and seem in V5R1 does not have identity function. how to handle this kind of problem in V5R1?????

    Thanks for your answer

  4. #4
    Join Date
    Sep 2004
    Posts
    1
    I'm not a expert in DB2 but in Internet I find a Oracle to DB2 UDB Conversion Guide.

    http://www.redbooks.ibm.com/redbooks/pdfs/sg247048.pdf

    I think that this guide can help you

Posting Permissions

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