Results 1 to 2 of 2

Thread: DB2 v/s oracle.

  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: DB2 v/s oracle.

    Sorry to chose this as the title..
    I wanted to know the DB2's equivalent od ROW-ID concept of oracle. If i do not explicitly mention during the DDL of Table creation (DB2) what is the other alternative?

    Thanks!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I am not sure about the row-id on Oracle, but in DB2 it must be defined as a column in the DDL to be used in SQL DML.

    A possible workaround is to access data via a cursor and then update/delete the row "where current of cursor." This helps where a unique key does not exist.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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