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
8028 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

What is deadlock in db2?

1070

List out the three types of page locks that can be held.

1149

How do I start db2 in windows?

1095

What is cursor in dbms?

1068

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727

Name the various locking levels available?

1093

How to find primary key of a table in db2?

1066

What is db2 purescale?

1004

What is db2 connect?

1069

Define sqlca.

1113

what are bind concepts in db2 cobol?

1093

What is dpf in db2?

1109

How do I add a column in db2?

1048

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

11675

What is the difference between cursor and select statement?

1102