In which column of which DB2 catalog would you find the
length of the rows for all tables?
- 2 Answers
- 10478 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
How can you quickly find out the # of rows updated after an update statement?
Explain various types of locks in db2?
Why do chiropractors use drop table?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How many databases are there?
Explain the function of data manager.
Explain the contention situations caused by locks?
What are the two types of logging in the db2 database? Explain them.
What are the different types of base tables?
How do we specify index to include or not during bind process.
What is the use of reorg in db2?
What is db2 bind process?
Mention the definition of cobol in varchar field.
How to retrieve rows from a db2 table in embedded sql?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
