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 dbrm?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the use of with ur in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is access path in db2?
What is bufferpool in db2?
What is the role of data manager in the db2 database?
What is the use of db2 optimizer?
What is ibm db2 database?
What is the default page size of buffer pools?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the various data types available in db2?
What is db2 command?
What is the latest version of ibm db2?
What is bind in db2?