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
- 11603 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
Which is faster delete or truncate?
What is a bind in db2?
Is db2 a mainframe database?
What is dclgen (declaration generator)?
How would the varchar column remarks defined?
What is load utility in db2?
What is dbrm? When it will be created?
Is db2 a database?
What is db2 optimizer?
What is a db2 table?
How does cobol compile db2 program?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is buffer pool in the db2 database?
What are the uses of db2 optimizer?
Mention some fields that are a part of sqlca.
