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

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2200

What is commit in db2?

1029

What is cursor with hold option in db2?

1052

What is check constraint in db2?

1062

What is ibm db2 client?

916

What are the different types of base tables?

1071

Can you use max on a char column?

1074

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8238

How and when does the db2 enforces the unique key?

1068

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1253

Which isolation level provides highest data integrity?

1092

What parameters are used to control the free space in DB2?

1039

What is ibm db2 used for?

1051

What does a deadlock mean in DB2?

1150

What are the two types of logging in the db2 database? Explain them.

1055