In which column of which DB2 catalog would you find the length of the rows for

In which column of which DB2 catalog would you find the
length of the rows for all tables?

Question Posted / guest

2 Answers
10458 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In which column of which DB2 catalog would you find the length of the rows for all tables?..

Answer / daphne

I assume that you mean "Column length" (Field length) for
all the fields of all the tables.

This can be found in SYSIBM.SYSCOLUMNS. The column name is
LENGTH.

If you want to find the column lengths of a particular
table then the query would be

Select NAME, LENGHT from SYSIBM.SYSCOLUMS where TBNAME =
<tablename>

Is This Answer Correct ?

1 Yes

0 No

In which column of which DB2 catalog would you find the length of the rows for all tables?..

Answer / vat

'RECLENGTH' column of SYSIBM.SYSTABLES would have the
record/row length of the table.

It's format: 8 + n + l where
8 accounts for 6 header bytes and 2 ID map entry bytes
n = 0 if there is no edit proc otherwise 10
l = Sum of max. col lengths (Add 1 byte for Null indicator
for nullable columns, 2 bytes for Varchar columns, 4 bytes
for LOB column)

and, RECLENGTH is 0 for auxilary tables, views and aliases

Is This Answer Correct ?

1 Yes

0 No

Post New Answer