Hi

I have a table TEST with some "normal" columns (int, char, ...) and a BLOB-column XML_FILE:
...
XML_FILE BLOB(4194304) NOT NULL,
...
In syscat.systables, I see that this table has 8262 records and uses 265 NPAGES. Does it mean that the table uses 265 * 4 KPages, INCLUDING the BLOB column, or not ? If not, could I determine the additional size of the BLOB column by:
Select sum(length(XML_FILE)) from TEST

Would that be correct ?

Thanks, Marc