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
- 11665 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 copy pending and check pending in db2?
What is view db2?
What is database manager in db2?
What is a db2 tablespace?
List down the data types in the db2 database.
What is null indicator in cobol db2?
Why do we use cursor?
What is check constraint in db2?
Is db2 a programming language?
How can you count the number of rows from a table tab?
What is rct?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Is db2 free?
Why do we bind in db2?
What is plan in cobol db2?
