What are the functions in DB2?
- 3 Answers
- 8260 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 the role of the data page in the db2 database?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the role of schema in the db2 database?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
how will you retrieve first record in table
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is a collection in db2?
What are the various locking levels available?
what is the use of bind parameter, Replace?
What are union and union all?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
COBOL 
