how we will do null data selection in cobol-db2 program

Question Posted / guest

Answers were Sorted based on User's Feedback

how we will do null data selection in cobol-db2 program..

Answer / adarshag

SELECT Name
FROM S-Tabl
WHERE Status IS NULL;

Is This Answer Correct ?

3 Yes

0 No

how we will do null data selection in cobol-db2 program..

Answer / shobha

by using null indicator

Is This Answer Correct ?

2 Yes

0 No

More DB2 Interview Questions

Is db2 a mainframe?

Can a Db2 table data be retrived through JCL?

What is JOIN and different types of JOIN.

What are the disadvantages of PAGE level lock?

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

how to resolve -811

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

What is bind in db2?

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

how to fetch multiple records without using cursor

How to define the a field which accepts value till 99999.99 in db2

For more DB2 Interview Questions Click Here