Archives of the TeradataForum
Message Posted: Tue, 31 Aug 2004 @ 13:42:35 GMT
| Subj: | | Re: How to get table names from table ids |
| |
| From: | | Dempsey, Mike |
The TVMId is a BYTE(6) not a CHAR(30), so you need it in hex.
Use
... Where TVMID = '01000C870000'xb.
I have not seen the display in PMON (usually it displays the Table Names directly ... unless you are running an older version of the
DBS.) but if it displays the ID as a series of separate hex values (eg. 0x0000 0xA5C4 0x0101) simply string these together (as in
'0000A5C40101'xb).
Mike Dempsey
Teradata Client Tools
| 
