What are the functions in DB2?
- 3 Answers
- 9603 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mainframe virumbi
the following functions ( Aggregate functions )applied on
the columns.
Count
Avg
Min
MAx
....
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / bhaskar reddy
the aggrigate function are
min, max, avg, sum, count
| Is This Answer Correct ? | 1 Yes | 0 No |
What is data manager?
How do you filter out the rows retrieved from a Db2 table ?
What are the functions in DB2?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to execute stored procedures?
Define declaration generator (dclgen).
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are the benefits of using the db2 database?
What information is used as input to the bind process?
What is cursor stability?
COBOL 
