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.
- 1 Answers
- 2651 Views
- Cap Gemini, I also Faced
- E-Mail Answers
What is the database descriptor?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
how can we retrieve the 100 records of the file ?
How do I delete a table in db2?
what is the maximum number of tables that can be joined ?
Name some fields from SQLCA.
What is the max length of sqlca?
how can u nderstand the sql stmts executed successfully or not ?
What are db2 objects?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
COBOL 
