Can you Average the Characters ?

Question Posted / naveen87ginjupalli

3 Answers
6132 Views
I also Faced
E-Mail Answers

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

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers

i want to maintain uniqueness on pdf without make lf??????????

0 Answers

what is Static and dynamic linking

1 Answers Virtusa,

How can you split a table in to exactly half?

7 Answers HSBC,

cursor with hold explain ?

1 Answers Verizon,

What are the benefits of using the db2 database?

0 Answers

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers IBM,

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers IBM,

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers

What are bind parameters in db2?

0 Answers

What is cursor with hold option in db2?

0 Answers

What is db2 command?

0 Answers

For more DB2 Interview Questions Click Here