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.
- 3 Answers
- 6510 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
How is deadlock resolved?
Is it possible using max on a char column?
What is page size in db2?
How can you classify the locks in db2?
Mention the definition of cobol in varchar field.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is a db2 cursor?
What is db2 bind process?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a storage group (stogroup)?
Is db2 relational database?
what is diffrence b/w file-aid tool and file-aid utility???
Can one database have multiple instances?
What is null indicator in db2?
Which isolation level provides maximum concurrency?
