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.
- 3 Answers
- 6511 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
Define db2 and its databases?
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?
Mention data types used in db2 ?
How can you count the number of rows from a table tab?
What are the various data types available in db2?
What is the function of logging in the db2 database?
B37 abend during spufi?
How does coalesce work?
What is a dbrm in db2?
What is ibm db2 client?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How is the value function used?
What is release/acquire in bind?
Where do you specify them?
What is the difference between db2 and oracle?
