Archives of the TeradataForum

Message Posted: Thu, 08 Nov 2001 @ 20:50:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Because it does exist in the primary data subtable, you could use SQL such as

SELECT * FROM CORPDBP2.PROVGACT4T WHERE ROWID='C4963B7900000100'xb;

(Note the byte-swap for each of the 4-digit values) to scan the table.

In the more general case you would probably use the "filer" utility. For your example, you might use this command in Filer:

ROW /L 0007 EE70 P 96C4 793B 0000 0001

	<Prev	Next>		<<First	<Prev	Next>	Last>>