Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2007
    Posts
    20

    Unanswered: Usage of ROWID datatype

    Hi all,

    Ver: DB2 8.1
    OS: LINUX/Windows

    can the datatype ROWID used in this particular version.

    If so, please i need the syntax to use it.

    Thanks,

    M.Sampath.
    DBA

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    ROWID is not a built in datatype for DB2 for LUW. Where are you getting this from? And what does it do?

    Andy

  3. #3
    Join Date
    Mar 2007
    Posts
    24
    It's available in DB2 for zOS v.8 so I assume it's available in other v.8 flavors.

    As far as syntax, what are you asking specifically? It's just another column in your table and is used to directly access a row in certain situations.

    Code:
    CREATE TABLE MYTABLE
    (TABLE_ROWID  ROWID NOT NULL GENERATED ALWAYS)
    
    SELECT TABLE_ROWID
    FROM MYTABLE
    
    etc.etc..

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Fumigator
    It's available in DB2 for zOS v.8 so I assume it's available in other v.8 flavors.
    That is an incorrect assumption.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Mar 2007
    Posts
    24
    Whoops.....

Posting Permissions

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