First letter Capital

spiceuser-nhkd7awb · 2011-05-06T10:40:00.000Z

I was wondering if there is an option with the UpCase function that would only upper case the first letter of a name field. I know I can do this with UpCAse and DownCase by upper casing the the first character and down casing the rest and concatinate them… Is there an easier way to do this? Thanks

spiceuser-j8daftaw · 2011-05-11T01:50:00.000Z

Hi,

I agreed with Siva’s solution.

sivakakani-aodlmfwt · 2011-05-11T01:19:00.000Z

If your source database is oracle then
write user defined SQL query using initcap() function
for example.

In emp table employee name first character is capital rest of all is small
then select empno,initcap(ename),sal,mgr, hiredate,comm,deptno from emp;

spiceuser-krsfdswu · 2011-05-10T04:23:00.000Z

Hi Friends,

Greetings!!!

If we want to change the letters with in string, then we can use field
function.

But, here we want to change the first letter to uppercase. So, for this
initcap() is available in Oracle. But, this type of function is available or
not in Datastage, I don’t know exactly.

I agreed with Ramesh’s solution for this…
By using Function’s in Transformer
upcase(column[1,1]:downcase(column[2,len(col)] then we got output…

venkatarameshkumar-w2cvlkoa · 2011-05-10T02:56:00.000Z

Hi,

By using Function’s in Transformer
upcase(column[1,1]:downcase(column[2,len(col)] then we got output…

Regards,
Ramesh

masoodshaik-gur4jajs · 2011-05-10T02:04:00.000Z

I think field function is only way to change uppercase and lowercase.

spiceuser-nhkd7awb · 2011-05-09T12:30:00.000Z

I am not using a Server job. And I only need the first initial Capitalized… I can do it just as I explained.

previoustoolboxuser · 2011-05-06T12:09:00.000Z

Hi,

In Datastage 8.1 there is a transform called CAPITALS that to this using server job.
You can find it in Designer, folder :
Transform / Built-In / String /

You just have to add:
" CAPITALS ( name field ) "
in a transformer of your server job

Regards,

Ghislaine Ndeutchi