What are the functions in DB2?
- 3 Answers
- 8543 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 |
Name some fields from SQLCA
How to find the number of rows in db2 tables?
What is a collection in db2?
Which catalog tables contain authorization information?
How Plan is created while executing the query using SPUFI?
What is isolation level?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is plan in cobol db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
difference between group clause and order clause
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
COBOL 
