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

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

What is cursor in dbms?

0 Answers  

---

What are iseries servers?

0 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

What is a result table?

1 Answers  

---

What is node in db2?

0 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---