How do you check for a null value in a db2 column?
- 2 Answers
- 11223 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.
| Is This Answer Correct ? | 32 Yes | 0 No |
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
| Is This Answer Correct ? | 1 Yes | 1 No |
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.
What is a db2 tablespace?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the information associated with sysibm.syslinks table?
What is dbrm in db2 database?
How many databases are there?
What is the difference between SYNONYM and ALIAS?
How can you count the number of rows from a table tab?
what is the difference between where clause and having clause
what is REORG? what is the use?
what is utility for parm lib
What is drop table?
COBOL 
