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

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?

8243

What is meant by dclgen?

1095

What do you mean by storage group (stogroup)?

1024

Mention the downsides of page level lock.

1149

How to retrieve rows from a db2 table in embedded sql?

1372

How to check sequence on a table in db2?

1046

Is db2 a database?

948

What is a db2 collection?

1022

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1083

How to find primary key of a table in db2?

1049

How can you count the number of rows from a table tab?

1077

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1053

What is database alias db2?

1105

What is the use of with ur in db2?

1035

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1084