In which column of which DB2 catalog would you find the
length of the rows for all tables?
- 2 Answers
- 11018 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / daphne
I assume that you mean "Column length" (Field length) for
all the fields of all the tables.
This can be found in SYSIBM.SYSCOLUMNS. The column name is
LENGTH.
If you want to find the column lengths of a particular
table then the query would be
Select NAME, LENGHT from SYSIBM.SYSCOLUMS where TBNAME =
<tablename>
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Define declaration generator (dclgen).
what happend with out using Commit,when closing cursor and program?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
Which transaction use a command thread ?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is a thread?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is null in db2?
What's The Error Code For Unique Index Voilation?
Which components manage deadlocks in db2?
What are the advantages of using a PACKAGE?
COBOL 
