IS THE COMPARISON POSSIBLE

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
KALYAN
Participant
Posts: 2
Joined: Thu Jan 06, 2005 3:17 pm

IS THE COMPARISON POSSIBLE

Post by KALYAN »

hi all,

i need a suggestion from u gurus.

in the process of MATCHING:

i have a field (CARDHID) in file A which is of length 12. In File B i have the PHSSN field of length 9. the first 9 characters of the CARDHID are same as the PHSSN for all records. is there a possible way that i can compare these two fields.
help me out.
thanks
kalyan.
Jay
Participant
Posts: 105
Joined: Tue Nov 11, 2003 8:28 pm

Post by Jay »

if compare(CARDHID[1,9], PHSSN) = 0 then they are equal else not equal.

try it.
KALYAN
Participant
Posts: 2
Joined: Thu Jan 06, 2005 3:17 pm

IS THE COMPARISON POSSIBLE

Post by KALYAN »

hi jay,
is it possible for me to give constraints in MATCH Stage of the Quality stage?

if yes how can i do that and where do i do that?

thanks
kalyan
PilotBaha
Premium Member
Premium Member
Posts: 202
Joined: Mon Jan 12, 2004 8:05 pm

Post by PilotBaha »

Too bad they don't teach COBOL any more :wink:

HEre's what you can do..

If you are absolutely and positively sure that the first 9 chars of (CARDHID)
are the same as the PHSSN, define two other varibles such that it will work like redefines in COBOL.

It will look like :

Code: Select all

CARDHID      1     12
CARDIDL       1     9
CARDIDH      10    3
Then use CARDIDL to match to PHSSN.

Does it make sense?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

PilotBaha beat me to it. Yes, it's a simple as creating a redefinition of the input file, so that there's another name that refers to the first nine characters of CARDHID.

You can then perform any kind of match between this and the nine character column in File B.

PS You can still learn COBOL, but it's definitely not as widespread as it once was.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply