hi all
is there any initcap function in DataStage.How can i do initcap in DataStage..
initcap
Moderators: chulett, rschirm, roy
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...
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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
