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

how can we find nth max salary from A table

how to fetch multiple records without using cursor

What is copy pending status in db2?

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

What are db2 tables?

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

Define db2 and its databases?

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

How to design maps

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

What is reorg and runstats in db2?

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

For more DB2 Interview Questions Click Here