Archives of the TeradataForum
Message Posted: Thu, 08 Nov 2001 @ 21:14:29 GMT
| Subj: || || Re: Identifying row failed in CHECKTABLE |
| From: || || Geoffrey Rommel |
| ||Is there a way to select the row from the table that is failing in CHECKTABLE?|| |
| ||"CORPDBP2"."PROVGACT4T" starting at 14:27:06 01/11/05.|
Table id 0007H EE70H, Fallback.
2764: Data row not indexed by USI.
Data AMP 00010, Primary Data subtable
USI id 4
Data row id 96C4H 793BH 0000H 0001H
Well, I've never actually had to do this, but the following should get you pretty close.
select d.databasenamei, t.tvmnamei, t.tvmid
from dbc.dbase d,
where d.databaseid = t.databaseid
and tvmid = '0007ee700000'xb ;
This will give you the name of the table. You can then find all rows that match your primary index value thus:
where hashrow(primary,index,values) = '96c4793b'xb ;