All Forums Database
Ravi1c 1 post Joined 10/14
09 Oct 2014
Where does the CHECKSUM metadata value for a table get stored in DBC Teradata catalog tables

Hi,
Am looking to find out where does the Checksum metadata values of the datable got stored.
Here when I run a query
CREATE TABLE "ravi"."Table1", FALLBACK , SINGLE BEFORE JOURNAL , CHECKSUM = HIGH (
        "Column1" CHARACTER(5),
        "Column2" CHARACTER(5)
    );
I can see the Journal options are store in the JournalFlag Column (http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/ index.html#page/Database_Management/B035_1092_112A/ Appendix_A_System_Columns.019.05.html).
 
Which can be found using the query "select select JournalFlag from DBC.Tables where DatabaseName = 'ravi' and TableName = 'Table1' "
I there any such way to know the value of the Checksum for a given table from the Teradata catalog tables, or is there any store procedure of utility to find out the value of checksum ?
Thanks in advance !!

-Ravi
dnoeth 4628 posts Joined 11/04
09 Oct 2014

CHECKSUM can't be found in any system table, it's only in the table header (similar to BLOCKSIZE).
The only way to get this info using SQL is a SHOW TABLE, otherwise only a low-level command line utility should be able to extract this info. Probably FILER, but this is mainly for TD support...

Dieter

You must sign in to leave a comment.