I found the code to emulate the functionality of MySQL SUBSTRING_INDEX function in an IBM Redbook, and would like to add this to my DB2 system.
I'm not a DBA in any way, but I have to manage the DB2 databases provided with the Tivoli products I use. I've search a ton, and I'm not really sure how to do this. I've tried using IBM Data Studio to create the function, but it fails.
Any guidance on how to create this UDF would be greatly appreciated.