DBC.ColumnsV ColumnFormat

Database
Fan

DBC.ColumnsV ColumnFormat

Can anyone suggest documentation anywhere to help me decipher the DBC.ColumnsV ColumnFormat column?  For example, a float column with ColumnFormat -9.99999999999999E-999?     Or an Integer column with -(10)9?  What exactly is that telling me?  Or a Decimal column with -(32)9.9(6)?    Or a Decimal column with ----------9.?

1 REPLY
Senior Apprentice

Re: DBC.ColumnsV ColumnFormat

FORMATs are manly based on COBOL syntax, e.g. '9' means a leading zero, '(n)' repeats the previous character n times.

See "Data Type Formats and Format Phrases" in the "SQL Data Types and Literals" manual:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1143_112A/ch09...