Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7894 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madhuri tungal
In the CUSTLOC field the no data is represented by SPACES
but not by .... i.e NULL VALUE
Hence the query would be,
SELECT * FROM CUST WHERE CUSTLOC IS SPACES;
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / sharat
EXEC SQL
SELECT * FROM CUST
WHERE CUSTLOC = NULL
END-EXEC.
Can anyone let me know whether the query coded above is right.
| Is This Answer Correct ? | 0 Yes | 6 No |
where can we use index and subscript ? with example ?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
Define buffer pool.
Is ibm db2 open source?
What is check constraint in db2?
Which one allows duplicate values Union or Union All ?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is a host variable?
What is a LIKE table and how is it created?
What is sqlca?
COBOL 
