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

Which command is used to remove all rows from a table?

1121

Why do chiropractors use drop table?

1115

What is meant by explain?

1140

What is dbrm?

1115

What does db2 stand for?

1036

What are host variables in db2?

1078

What is ibm db2 client?

948

What is the maximum No of rows per page?

1076

What is innodb buffer pool?

1066

What is coalesce in db2?

1143

Define db2.

1121

What is commit in db2?

1065

What are iseries servers?

1083

What is dpf in db2?

1117

What is the difference between nvl and coalesce?

1069