Interested to Buy Any Domain ? << Click Here >> for more details...
In which column of which DB2 catalog would you find the
length of the rows for all tables?
- 2 Answers
- 11759 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is dclgen (declaration generator)?
Explain package in db2 and its advantages?
How to find the number of rows in a db2 table?
what is utility for parm lib
How can you do the explain of a dynamic sql statement?
What is bufferpool in db2?
How do I change the column size in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the difference between cursor and select statement?
Explain packages.
What is a storage group (stogroup)?
What is package in cobol db2?
Why cursor is used in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Mention the location where the output received from explain statement is stored.
