The EE Engine doesn't have such a function. If performance is not a consideration then you can use a BASIC transformer stage in your job and do the conversion with OCONV(In.Column,'MCN'). Either that or write your own c++ function to do the initial caps and call that.
I guess I did mean MCT. I wasn't sure which conversion it was, lacking the manuals, and actually had MCP down until I remembered that it didn't do what the poster requested.
Hi, I see a built-in transform CAPITALS is available under Transform/Built-In/String that converts a string to word-initial capitals. but how I do use CAPITALS built-in transform that convert the first letter of each to uppercase and remaining string to lower case.
I am unable to drag and drop this transform or I am missing something.
could you briefly explain how I can use this in DataStage Parallel job flow.