DB2 column functions and scalar functions

DB2 column functions are one of our most commonly used functions. They calculate a group of values in the column to obtain a single result value. Let's take a look at the DB2 column functions.

DB2 column Functions

DB2 column functions perform operations on a group of values in a column to obtain a single result value. The following is an example of some column functions.

AVG
Returns the sum of the values in a group divided by the number of values in the group.

COUNT
Returns the number of rows or values in a group.

MAX
Returns the maximum value of a group of values.

MIN
Returns the minimum value of a set of values.

DB2 scalar functions

A scalar function performs an operation on the value to return another value.
The following are some examples of scalar functions provided by the DB2 Universal Database.

ABS
Absolute Value of the returned number

HEX
Hexadecimal representation of the returned value

LENGTH
Returns the number of bytes in the independent variable. returns the number of double-byte characters for a string .)

YEAR
Extract the year of the datetime Value

Four file formats for DB2 data movement

DB2 mount command performance factors

Deep analysis DB2 modification table

DB2 rename a table and view table information

DB2 index syntax