In which column of which DB2 catalog would you find the
length of the rows for all tables?
- 2 Answers
- 10485 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
Explain dclgen.
What is the difference between spufi and qmf?
What is meant by dclgen?
How do I delete a column in db2?
Explain in detail about buffer manager and its functionalities?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Can one database have multiple instances?
How to test SQL -911 error while developing COB-DB2 program
What is the maximum No of rows per page?
How do I create a view in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the difference between using bind () and rebind () methods of naming class?
What is dbrm in db2 database?
What is db2 bind?
What are bind parameters in db2?
