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
- 7898 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 |
What is query_cache_limit?
Outputs of explain are with matchcols = 0. What does this signify?
What is an asychronous write?
What is a bind card?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is release/acquire in bind?
I use CS and update a page. Will the lock be released after I am done with that page?
Explain the contents that are a part of dclgen.
What is the use of predicate?
what is consistency token
COBOL 
