Comparison Query

sibi Yohannan · New User Joined: 15 Apr 2009 Posts: 47 Location: Bangalore

HI,

Please advice me on the below query,

In database we have some data in Capital Letters , Lets say ABC.
But we get some data as "abc" from other systems, AND when we compare these two, it will not match.

As per our requirement, it differes only in Capital Letters and Small Letters. What can be done to match them?

Thanks

Bharath Bhat · Posted: Thu Jan 21, 2010 5:52 pm

Check This.

mftrigger · New User Joined: 18 Feb 2006 Posts: 23 Location: chennai

Sibi,

Be clear while providing the requirements. Do tell us the following:
- what technique you have used to compare
- what do u mean by database - is it DB2.. or file processing in cobol ?

Soln. : There are many ways to compare this case. One way is convert the data to upper case or lower case and then compare..

Note:
===
As the Q, so the Answer. If your Question is vague, the solution you would recieve will also be vague

sibi Yohannan · New User Joined: 15 Apr 2009 Posts: 47 Location: Bangalore

The data in Upper case is in DB2.
The lower case data comes from an another system in a file.

I am simply using a euqal comparison by the two variables in a COBOL program.

Please advice

dbzTHEdinosauer · Posted: Thu Jan 21, 2010 6:22 pm

IF FUNCTION UPPERCASE (VAR1) = FUNCTION UPPERCASE (VAR2)

mftrigger · New User Joined: 18 Feb 2006 Posts: 23 Location: chennai

LC to UC in Cobol

In this you cud either use INSPECT or LOWER-CASE function.
The soln. is already in forum. Please chk b4 posting Qs.