EXEC SQL SELECT * FROM CUST WHERE CUSTLOC = NULL END-EXEC. Can anyo

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 / sharat

3 Answers
8029 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / sharat

EXEC SQL
SELECT * FROM CUST
WHERE CUSTLOC = NULL
END-EXEC.
Can anyone let me know whether the query coded above is right.

Is This Answer Correct ?

0 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where do you specify them?

1281

Explain db2.

1036

What is the use of predicate?

1043

What does runstats do in db2?

1119

What is dbrm library?

1055

How do I import data from excel to db2?

1074

What is a cursor in programming?

1069

What is isolation level in db2?

1005

What's The Error Code For Unique Index Voilation?

1239

What is access path in db2?

986

What is the physical storage length of timestamp data type?

1095

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

1074

What is explain plan in db2?

996

What is the role of data manager in the db2 database?

1109

How is deadlock resolved?

1146