All Forums Database
UpaMishra 35 posts Joined 01/08
13 Mar 2008
rowid in Teradata

I want to use rowid to update a table . sel rowid,emp_id,e_name from test; ****************************************************** *************result set--- >***************************************************** ***************ROWID EMP_Id E_NAME0000C500B17E00000100 1203 RAVI0000540D424200000100 1201 RAVI000099930AA400000100 1200 dk00004042C1A200000100 1111 Hello, world!0000B9C9639300000100 1640 Santosh0000FE4F2CF500000100 1639 upendra000040CF7B1300000100 1945 raman************************************************* *******************Then I tried the following Query.sel e_name from test where rowid='0000C500B17E00000100';AND It is giving the following error......................................3640: comparing BYTE data in column in column ROWID with other data types is illegalcan anyone Plz tell why this error is throwing.Is there any other way to use rowid to update or simply select from a table.

foxbat 27 posts Joined 06/07
13 Mar 2008

Byte data must be suffixed with 'xb'. Try the following.sel e_name from test where rowid='0000C500B17E00000100'xb;-Foxbat

UpaMishra 35 posts Joined 01/08
13 Mar 2008

By giving xb sufix ,it works.Thanks for the information.

11 Sep 2008

can this be done in V2R5?I tried it and it says 3706: syntax error: ROWID not allowed.

mccray57 1 post Joined 09/08
12 Sep 2008

ROWID is a reserved word and cannot be referenced in the WHERE clause in R5. It is allowed in JOIN INDEX creation. In R5.0.x you can enable the "use" of ROWID, for backward compatibility purposes, with a INTERNAL flag setting in DBSCONTROL; but technical issues are not supportable as it is explicitly stated that ROWID is not supported in SQL query syntax in R5. After R5.0.x, NCR has disabled the DBSCONTROL setup option. So in the Teradata RDBMS newer than R5.0.x, ROWID is not allowed to be queried by using SQL.

You must sign in to leave a comment.