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

Question Posted / guest

2 Answers
7119 Views
Wipro, I also Faced
E-Mail Answers

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

Post New Answer

More DB2 Interview Questions

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers IBM,

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers TCS,

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers Accenture,

what is rebinding ?

1 Answers IBM,

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers MCN Solutions,

What is a correlated sub query?

2 Answers

What is a lock?

1 Answers

Define check constraint.

0 Answers

Which is faster delete or truncate?

0 Answers

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers

Is ibm db2 free?

0 Answers

What is the use of predicate?

0 Answers

For more DB2 Interview Questions Click Here