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
- 8049 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 |
What is the difference between bind and rebind in db2?
What are union and union all?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is correlated subquery?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
How to find the number of rows in a db2 table?
How do I start db2 in windows?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is meant by isolation level?
what is Runstats? Whem will u choose to runatats?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
COBOL 
