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
- 8044 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
What is buffer pool and list some of them?
what is a corelated subquerry?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is meant by union and union all?
What happens in bind step in a db2 program?
How many databases can be created inside an instance in db2 ?
Highlight all the advantages that are attached to a package.
What is load utility in db2?
How would the varchar column remarks defined?
what is the sqlcode -501
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How can you quickly find out the # of rows updated after an update statement?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Is db2 a mainframe?
What is blu acceleration in db2?
