 |
 |
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,
dbc.tvm t
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:
select ...whatever...
from your.table
where hashrow(primary,index,values) = '96c4793b'xb ;
| |
