Data type for rowid

[alwaysAnewbie]

I have been through every manual here and can't find the information.

I am trying to store the rowid from a table into a stored procedure variable. I assume the type is byte but what is the length.

 

[tdsmart]

Its simple - Byte(8):

sel type(rowid) from dbcinfotbl;

*** Query completed. 2 rows found. One column returned.
*** Total elapsed time was 1 second.

Type(ROWID)
---------------------------------------
BYTE(8)
BYTE(8)

 

[tdatgod]

Hi,
ROWIDs are internal to the Teradata database and there is no guarentee that they won't change from table to table.

for example take a table, load it, update it, delete some records,insert more records....

Then insert select it into another table and the rowids will

NOT

match.

Also in V2r5 the format of Rowids may actually change to 10 bytes for certain types of tables.

Therefore please don't rely on Rowids to mean anything other than the ability to locate the current row at the current moment in time.


-----

 

[alwaysAnewbie]

Thanks for the help guys. I am new to Teradata from Oracle and I am learning by the moment.