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
8144 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

Explain packages.

1171

What do you mean by cursor?

1032

What is cursor stability in db2?

1415

List out the three types of page locks that can be held.

1193

What are host variables in db2?

1122

What is rct?

1290

What is the clustering index in the db2 database?

1047

Which components manage deadlocks in db2?

1124

What is package in cobol db2?

1163

What is data manager?

1103

Mention the downsides of page level lock.

1217

How to create backup table in db2?

1150

What is netezza database?

1082

What is an instance database?

1098

What is the picture clause of null indicator variable?

1183