Can you Average the Characters ?

Answers were Sorted based on User's Feedback



Can you Average the Characters ?..

Answer / knight

will return sqlcode= -171

Is This Answer Correct ?    2 Yes 0 No

Can you Average the Characters ?..

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

Can you Average the Characters ?..

Answer / naveen87ginjupalli

Yes,we can Average the characters
SELECT AVG(EMP-NAME) FROM EMP;

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More DB2 Interview Questions

What is a cursor?

2 Answers  


what are bind concepts in db2 cobol?

0 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  


What is difference between alias and synonym in db2?

0 Answers  






Are view updateable?

0 Answers  


What is scrollable cursor in db2?

0 Answers  


What is copy book?

1 Answers   Thomson Reuters,


What parameters are used to control the free space in DB2?

0 Answers  


Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


What is a SELECT statement?

1 Answers  


How to update more then one record using update?

5 Answers   IBM,


Categories