I am having n number of records in a table which consists of emp-name is one of

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

1 Answers
2546 Views
Cap Gemini, I also Faced
E-Mail Answers

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 the latest version of ibm db2?

0 Answers

How is the value function used?

0 Answers

What is buffer pool in the db2 database?

0 Answers

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers IBM,

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers Accenture,

How Plan is created while executing the query using SPUFI?

3 Answers

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers

What are db2 tables?

0 Answers

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers iGate,

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers Cap Gemini,

What is drop table?

0 Answers

For more DB2 Interview Questions Click Here