1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

Question Posted / sudheern


I am having n number of records in a table which consists of emp-name is one of the field among them..

Answer / chandra

Use INITCAP() Function

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is meant by AUTO COMMIT?

3 Answers  

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

What are the bind parameters ibm db2?

0 Answers  

What is a DB2 access path?

1 Answers  




Is there any advantage to denormalizing DB2 tables?

1 Answers  

Is Cursor exicutable ?

3 Answers   TetraSoft,

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

How do I add a column to a table in db2?

0 Answers  

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

For more DB2 Interview Questions Click Here
Categories