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>

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

What is the difference between bind and rebind in db2?

0 Answers  

---

What is dbrm in db2 database?

0 Answers  

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

What are the advantages of using a PACKAGE?

2 Answers  

---

How do you define a correlated name?

1 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What are the three types of page locks that can be held?

1 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

what is SPUFI ?

2 Answers  

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---