CAPITALS - Convert a string to word-initial capitals

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
janreddy
Participant
Posts: 15
Joined: Tue Apr 07, 2009 9:57 am

CAPITALS - Convert a string to word-initial capitals

Post by janreddy »

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.

Thanks
Jana
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It's a Server object, so you'd either need to use it in a Server job or a BASIC Transformer.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Moderator: please move to parallel forum
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply