DSXchange

hi all
is there any initcap function in DataStage.How can i do initcap in DataStage..

Yes.

First suggestion would be to check the BASIC section of the online Help. There's a part where it lists functions based on what kind of operation you need to do. You would have found your answer there.

Direct answer is there is an OConv conversion code to do this, but I don't recall it off the top of my head. Biggest reason for that is because I don't need to - there are Transforms that make it easier to use and self-documenting. The one you are looking for is Capitals and I suggest you open it up in the Manager and see how it was defined, perhaps even read up on on the conversion code, rather than just type it in and use it.

Teach a man to fish...

There is no initcap function in PX Transformer as such. I think you have to write a parallel routine for that.

Thanks,
Ajith

Just for you, I logged into work to get the gory details on helping you help yourself.

Turns out this particular 'task' isn't listed where I pointed you, although many others are. However, going to transforms (server jobs) in the Index does turn it and its brethren up in the string sub-category.

Suggest you read through all of the transforms as they can come in rather handy.

ajith wrote:There is no initcap function in PX Transformer as such. I think you have to write a parallel routine for that.

Posted as a 'Server' question, hence my answer.

chulett wrote:

ajith wrote:There is no initcap function in PX Transformer as such. I think you have to write a parallel routine for that.

Posted as a 'Server' question, hence my answer.

My Mistake , You are right

The ICONV/OCONV conversion code that gets this done is "MCT".