Can you Average the Characters ?
Answers were Sorted based on User's Feedback
Answer / sudhakar
No will get an Error -
-420
The value of a string argument was not acceptable to the function-name function
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen87ginjupalli
Yes,we can Average the characters
SELECT AVG(EMP-NAME) FROM EMP;
| Is This Answer Correct ? | 4 Yes | 9 No |
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
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.
What are leaf pages?
What is runstats and reorg in db2?
Is there any advantage to denormalizing DB2 tables?
How can you do the explain of a dynamic sql statement?
What is a clustering index?
What is a view? Why use it?
What is clone table?
Explain about cursor stability?
What can the SET option of the Repair Utility accomplish?
When reorg is used?