Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8152 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
Is db2 a mainframe?
What is explain plan in db2?
Name the lockable units in DB2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the use of with ur in db2?
Give a brief description of db2 isolation levels?
Explain about cursor stability?
what is the sqlcode -501
What are the different types of base tables?
What is nvl in db2?
Why do we need reorg in db2?
How to fetch the last row from the table in SQL (db2)?
What is view db2?
What is dbrm in db2 database?
Who uses db2?
