Answer / guest

You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.

Answer / angoca

By querying the catalog
select nulls
from syscat.columns
where tabschema like 'XX%'
and tabname = 'YY'
and colname = 'ZZ'"

Or with the describe command
db2 describe table ZZ.YY

where will u check for sqlcode ?

2 Answers   TCS,

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What is a SELECT statement?

1 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

What is tablespace?

3 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

what is rebinding ?

1 Answers   IBM,

---

Explain about rct.

0 Answers  

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---

What is netezza database?

0 Answers  

---

What is a recovery log?

1 Answers  

---