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
- 8148 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vineet chauhan
no you have to use IS keyword as:
SELECT * FROM CUST
WHERE CUSTLOC IS NULL
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / 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 |
Answer / 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 |
I use CS and update a page. Will the lock be released after I am done with that page?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
List down the types of triggers in the db2 database?
What is a buffer in memory?
what is consistency token
What does an outer join do?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is meant by concurrency?
what is the sqlcode -501
how we will do null data selection in cobol-db2 program
where will u check for sqlcode ?
What are iseries servers?
COBOL 
