Catalog query

[Sam Durai]

Hello, How can I identity the list of columns (with the table in which
it is located) present in a database which has
[1] A blank or NULL value for ALL rows ( if the column is CHAR)
[2] A zero (0) for ALL the rows (if it is a numeric column)

Is there is any system.catalog entry which I can query to find out ?

Thanks, Sam

[Ian]

Sam Durai wrote:

Hello, How can I identity the list of columns (with the table in which
it is located) present in a database which has
[1] A blank or NULL value for ALL rows ( if the column is CHAR)
[2] A zero (0) for ALL the rows (if it is a numeric column)

Is there is any system.catalog entry which I can query to find out ?

No. You must query the actual tables to get accurate results.

However, if you've have recent statistics on the tables, you may be
able to get a rough idea by looking at syscat.tables (CARD) and
syscat.columns (COLCARD, HIGH2KEY, LOW2KEY, NUMNULLS, ...)