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 daily...

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 getting...

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 gene...