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
- 11555 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
Is db2 a database?
Mention the various locks that are available in db2.
Is db2 relational database?
Explain about rct.
Explain various types of locks in db2?
what is the role of the cursor in db2?
Mention data types used in db2 ?
What are foreign keys in db2?
Why do we need reorg in db2?
What is db2 look?
How do we specify index to include or not during bind process.
Differentiate between cs and rr isolation levels? Where do you specify them?
What is dbrm? What it contains?
What is sqlca’s maximum length?
Define check constraint.
