In the CUSTLOC field the no data is represented by SPACES but not by ....

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.

Question Posted / madhuri tungal

3 Answers
8153 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

Please Help Members By Posting Answers For Below Questions

Is ibm db2 open source?

1132

What is the result of open cursor statement?

1129

What are the bind parameters ibm db2?

1105

How to create backup table in db2?

1150

What is copy pending and check pending in db2?

1049

What does reorg do in db2?

1079

What is load utility in db2?

1235

What is rct?

1296

What is the role of schema in the db2 database?

1366

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11746

What is the meaning concurrency in the db2 database?

1172

What is universal database?

1122

What do you mean by storage group (stogroup)?

1083

How can you find out the # of rows updated after an update statement?

1158

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2914