Initcap function

[PatelRam]

In Oracle we have initcap function

What is equivalent in db2...???

 

[pkganapathi]

What does initcap do in Oracle?

-PK.Ganapathy
DB2 DBA
TCS

 

[PatelRam]

Table a:

Name
====
john smith
peter sam

Oracle Sql: Select initcap(name) from a
Output :

Name
====
John Smith
Peter Sam

It will make upper case for 1st character of the all the word in a column

 

[sathyarams]

Nothing as far as I know ..

You could probably write a UDF

Cheers
sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

 

[mctesta]

Select ucase(name) from a

 

[MarcLodge]

MC's solution will make the whole column upper case. Because you need to change the letter of the 2nd name, which can appear anywhere in the string, I don't think it can be done in SQL. You will need to do this programatically outside of SQL. Call the routine as a UDF as Sathyaram suggests.

 

[ManuGenard]

Visit the excellent IBM DB2 DeveloperDomain site, there is link to porting to DB2 with migration info.
Among these, you'll find a UDFMigration package which includes the code to recreate some 30 or so Oracle functions, the InitCap is one of these.

http://www-106.ibm.com/developerworks/db2/library/samples/db2/0205udfs/

It works great and accepts any string, special characters and so on.