What are the functions in DB2?
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 the usage of open cursor command?
On which levels locks can be applied?
How to resolve -407 sql code in DB2?
Explain the function done by data manager?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Explain packages.
What is a DB2 bind?
What is index cardinality?
What are the three lock types?
What is the difference between using bind () and rebind () methods of naming class?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference