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.
Answer Posted / chandra
Use INITCAP() Function
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a Foreign Key?
What is db2?
What is a db2 cursor?
What is table space in db2?
What is lock escalation in db2?
What is db2 look?
What is difference between isnull and coalesce?
Mention the different locking levels that are available in db2.
Can there be more than one cursor open for any program?
Are views updateable?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is phantom read in db2?
Explain the contents that are a part of dclgen.
How to view db2 table structure?
How to get the ddl of a table in db2?