|
View previous topic :: View next topic
|
| Author |
Message |
kannag
New User
Joined: 02 Aug 2006
Posts: 23
Location: chennai
|
|
|
|
hi all,
Suppose i have an customer table having fields like customer-id,customername,customer-address,customer-telephone.
I want to find out which customer telephone number is empty?.then i want to upgrade that field.and i want to update the customers current adress too?
anyone can give query to find out the empty rows? |
|
| Back to top |
|
 |
sri_mf
Active User
Joined: 31 Aug 2006
Posts: 218
Location: India
|
|
|
|
| kannag wrote: |
hi all,
Suppose i have an customer table having fields like customer-id,customername,customer-address,customer-telephone.
I want to find out which customer telephone number is empty?.then i want to upgrade that field.and i want to update the customers current adress too?
anyone can give query to find out the empty rows? |
HI kanna wat do u mean by empty?is it null if so here is the query.
select * from customer where customer-telephone = NULL
u select the fields according ur requirements.here i have selected all. |
|
| Back to top |
|
|
kannag
New User
Joined: 02 Aug 2006
Posts: 23
Location: chennai
|
|
|
|
hi all,
Suppose i have an customer table having fields like customer-id,customername,customer-address,customer-telephone.
I want to find out which customer telephone number is empty?.then i want to upgrade that field.and i want to update the customers current adress too?
anyone can give query to find out the empty rows?
and also i want cobol coding for above requirement |
|
| Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006
Posts: 218
Location: India
|
|
|
|
| kannag wrote: |
hi all,
Suppose i have an customer table having fields like customer-id,customername,customer-address,customer-telephone.
I want to find out which customer telephone number is empty?.then i want to upgrade that field.and i want to update the customers current adress too?
anyone can give query to find out the empty rows?
and also i want cobol coding for above requirement |
here is the cobol code
exec sql
query
end-exec.
EVALUATE SQLCODE
when sql-code-ok
do the chnages u require
when sql-code-not-found
display relevant message
when other
abend the program.
end-evaluate.
kanna in each when i have given explanation there u have to check ur sqlcode.let me know if u have any more issues.
correct me if i m wrong |
|
| Back to top |
|
|
|
|
