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
- 6512 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define declaration generator (dclgen).
What is plan in cobol db2?
What is explain in db2?
What is null indicator in cobol db2?
How is deadlock resolved?
is it compulsory commitment control in journal?
How connect db2 database to datastage?
What is null indicator in db2?
What is runstats db2?
What are the various data types available in db2?
What is the physical storage length of time data type?
How is the value function used?
How many databases can be created inside an instance in db2 ?
How does coalesce work?
What db2 400?
