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 does DB2 store NULL physically?
What are leaf pages?
Where do you specify them?
Mention the downsides of page level lock.
What does db2 blu stand for?
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 .....
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
what is sql abend code -801,-802?
In which column of which DB2 catalog would you find the length of the rows for all tables?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How will fetch last 5 rows from table in db2