Mainframe, MVS and zOS Discussion

Hi, Thanks for your inputs. Do you know how to write FUNCTIONS in DB2 and deploy it in DB2? I need to write a function and implement it in prod. once that is implemented, My ab-Initio team will read the columns extract along with this Function and work on the report creation.

My job: To write a DB2 ...

The catch here is the address field might have multiple words

Can you explain this with example data in table and file?

PB: Table column would have data like below:

123 HANGING GARDEN ROSEWOOD BLVD KT
544 ROSEBERRY STREET XAVIOUR CT
399 CANTT INN PALM STREET DNT

where as the file that comes in ...

Thanks for your explanation. I know how SOUNDEX works. Being new to the group and also in a hurry, I probably could not put my requirement in correct way. Please see below:

I have address field in one of the columns of a DB2 table. I need to compare this address to the address field that I'm ...

Hi Anuj,

I could not find where to post questions?

I have a query. I have a string in DB2 column which contains address something like "312 MOUNT MARY ROAD BOXTER LVL JPN". Now I need to pass this db2 column thru a SOUNDEX option to generate a key out of it and compare the similar key generated ...