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
2539 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 temporal table in db2?

0 Answers

What is database manager in db2?

0 Answers

How can you do the explain of a dynamic sql statement?

0 Answers

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers CGI, Wipro,

What is load utility in db2?

0 Answers

What is buffer pool and list some of them?

0 Answers

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers IBM,

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

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers

For more DB2 Interview Questions Click Here