Good morning. A co-worker of mine has a program with the following SQL statement in it. This program has been running for 2 days now and I'm wondering if it's because of this code. What he's doing is converting customer information from one system to another and the names, addresses, etc. can be any combination of upper and lower case, so he's trying to identify if the customer has already been written by converting everything to uppercase. I just wonder if, when processing against a large file, 800K records, if there is a simplier way of determining if a record exists. Here's his statement:
exec sql select count(*) into :count from nciadr where
admrrn=:store and upper(ademl1)=upper(:email) and
Does converting everything to uppercase before getting a count run slow? Any suggestions would be greatly appreciated.