Usage of ROWID datatype

sampathm_78 · #1 (**permalink**) 04-10-07, 07:52

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

ARWinner · #2 (**permalink**) 04-10-07, 08:08

ROWID is not a built in datatype for DB2 for LUW. Where are you getting this from? And what does it do?

Andy

Fumigator · #3 (**permalink**) 04-10-07, 17:36

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..

Marcus_A · #4 (**permalink**) 04-10-07, 17:56

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.

Fumigator · #5 (**permalink**) 04-11-07, 13:31

Whoops.....

Internet Services

Web Development

Digital Marketing

Consumer Tech