What are the functions in DB2?

Answer Posted / mainframe virumbi

the following functions ( Aggregate functions )applied on
the columns.

Count
Avg
Min
MAx
....

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give the name of some fields form sqlca.

812


How do I import a csv file into db2?

739


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2002


How can you find out the # of rows updated after an update statement?

850


How can we retrieve the total number of records in RPG & CLLE?

364


What db2 400?

893


What is consistency token in db2?

857


Can we update view in db2?

757


How does cobol compile db2 program?

802


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

895


can all users have the privilage to use the sql statement select * (dml)?

839


Which component is used to execute the sql statements?

829


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

903


Is it possible using max on a char column?

834


What is a db2 package?

783