no you have to use IS keyword as: SELECT * FROM CUST WHERE CUSTLOC

Say CUST Table contains records like:
CUSTNO CUSTNAME CUSTLOC
100 ABC SSS
200 XYZ
300 PQR
400 MNO WWW
500 CVV
-------------
-------------
Now write a query to retrieve all records with CUSTLOC no
data.

Question Posted / vineet chauhan

3 Answers
7992 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / vineet chauhan

no you have to use IS keyword as:

SELECT * FROM CUST
WHERE CUSTLOC IS NULL

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is buffer pool in the db2 database?

1081

What is ibm db2 used for?

1053

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1083

What is cascading rollback?

1191

Why do we use cursor?

1085

What is reorg and runstats in db2?

1204

what is the sqlcode -501

13080

What is an instance database?

1035

what is diffrence b/w file-aid tool and file-aid utility???

4874

How to execute stored procedures?

1110

What is sqlca’s maximum length?

1152

What do you mean by between and in? Is between inclusive of specified range values?

1078

What is check constraint in db2?

1062

What do you mean by rollback?

978

What is collection in db2 bind?

991