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
- 11509 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
Are views updateable?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How and when does the db2 enforces the unique key?
How does a cursor work?
Why do we need reorg in db2?
What is null in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is clone table?
What is the result of open cursor statement?
Which components manage deadlocks in db2?
Highlight all the advantages that are attached to a package.
How to find schema of a table in db2?
What is a system catalog table in db2?
What is query_cache_limit?
What is cloudant database?
