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.
IS THE COMPARISON POSSIBLE
IS THE COMPARISON POSSIBLE
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
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
Too bad they don't teach COBOL any more
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 :
Then use CARDIDL to match to PHSSN.
Does it make sense?
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
Does it make sense?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.