List of supported built-in functions and user-defined functions supplied with Db2

This section contains an alphabetical list of the built-in functions and supplied user-defined functions that Db2 for z/OS® supports.

Table 1. Supported built-in functions

Function name	Description
ABS or ABSVAL scalar function	Returns the absolute value of its argument
ACOS scalar function	Returns the arc cosine of an argument as an angle, expressed in radians
FL 507 ADD_DAYS scalar function2	Returns a datetime value that represents the first argument plus a specified number of days
ADD_MONTHS scalar function	Returns a date that represents the date argument plus the number of months argument
ADMIN_TASK_LIST table function 1	Returns a table with one row for each of the tasks that are defined in the administrative task scheduler task list
ADMIN_TASK_OUTPUT table function	Returns the output parameter values and result sets, if available. If the task that was executed is not a stored procedure or the requested execution status is not available, the function returns an empty table.
ADMIN_TASK_STATUS table function 1	Returns a table with one row for each task in the administrative task scheduler task list that contains the status for the last time the task was run
ARRAY_AGG aggregate function	Returns an array in which each value of the input set is assigned to an element of the array
ARRAY_DELETE scalar function	Returns an array with the requested elements deleted.
ARRAY_FIRST scalar function	Returns the minimum array index value of an array.
ARRAY_LAST scalar function	Returns the maximum array index value of an array.
ARRAY_NEXT scalar function	Returns the next larger array index value for an array, relative to a specified array index argument.
ARRAY_PRIOR scalar function	Returns the next smaller array index value for an array, relative to a specified array index argument.
ARRAY_TRIM scalar function	Returns an array after removing elements from the end of an ordinary array.
ASCII scalar function	Returns the ASCII code value of the most character of the argument as an integer
ASCII_CHR scalar function	Returns the character that corresponds to the ASCII code value that is specified by the argument
ASCII_STR or ASCIISTR scalar function	Returns an ASCII version of the character or graphic string argument
ASIN scalar function	Returns the arc sine of an argument as an angle, expressed in radians
ATAN scalar function	Returns the arc tangent of an argument as an angle, expressed in radians
ATANH scalar function	Returns the hyperbolic arc tangent of an argument as an angle, expressed in radians
ATAN2 scalar function	Returns the arc tangent of x and y coordinates as an angle, expressed in radians
AVG aggregate function	Returns the average of a set of numbers
BLOB scalar function	Returns a BLOB representation of its argument
BLOCKING_THREADS table function 1	Returns a table with one row for each lock or claim that threads hold against the databases that are specified in the input parameter
BIGINT scalar function	Returns a big integer representation of its argument
BITAND, BITANDNOT, BITOR, BITXOR, and BITNOT scalar functions	Return a corresponding base 10 integer value in a data type that is based on the data type of the input arguments
BINARY scalar function	Returns a fixed-length binary string representation of its argument
BSON2JSON scalar function	Converts a JSON document in binary format (extended BSON) into a readable JSON text format.
FL 507 BTRIM scalar function2	Removes the characters that are specified in a trim string from the beginning and end of a source string
CARDINALITY scalar function	Returns a value of that represents the number of elements of an array
CCSID_ENCODING scalar function	Returns the encoding scheme of a CCSID with a value of ASCII, EBCDIC, UNICODE, or UNKNOWN
CEILING or CEIL scalar function	Returns the smallest integer greater than or equal to the argument
CHAR scalar function	Returns a fixed-length character string representation of its argument
FL 506CHARACTER_LENGTH or CHAR_LENGTH scalar function	Returns the length of its argument in the number of string units that are specified
CHR scalar function	Returns the character that corresponds to the ASCII code value that is specified by the argument
CLOB or TO_CLOB scalar function	Returns a CLOB representation of the first argument
COALESCE scalar function	Returns the first argument in a set of arguments that is not null
COLLATION_KEY scalar function	Returns a string that represents the collation key of the argument in the specified collation
COMPARE_DECFLOAT scalar function	Returns a SMALLINT value that indicates whether two arguments are equal, or unordered, or whether one argument is greater than the other
CONCAT scalar function	Returns the concatenation of two strings
CONTAINS scalar function	Returns a result about whether or not a match was found during a search of a text search index
CORR or CORRELATION aggregate function	Returns the coefficient of the correlation of a set of number pairs
COS scalar function	Returns the cosine of an argument that is expressed as an angle in radians
COSH scalar function	Returns the hyperbolic cosine of an argument that is expressed as an angle in radians
COUNT aggregate function	Returns the number of rows or values in a set of rows or values
COUNT_BIG aggregate function	Same as COUNT, except the result can be greater than the maximum value of an integer
FL 506 COVAR_POP or COVARIANCE or COVAR aggregate function	Returns the population covariance of a set of number pairs
COVAR_SAMP or COVARIANCE_SAMP aggregate function	Returns unbiased sample covariance (n-1) of a set of number pairs
FL 504 CUME_DIST 2	Returns a cumulative distribution of a row in an OLAP window
FL 504 CUME_DIST aggregate function 2	Returns the cumulative distribution of a row that is hypothetically inserted into a group of rows
DATE scalar function	Returns a date derived from its argument
DAY scalar function	Returns the day part of its argument
DAYOFMONTH scalar function	Similar to DAY
DAYOFWEEK scalar function	Returns an integer in the range 1–7, where 1 represents Sunday
DAYOFWEEK_ISO scalar function	Returns an integer in the range 1–7, where 1 represents Monday
DAYOFYEAR scalar function	Returns an integer in the range 1–366, where 1 represents January 1
DAYS scalar function	Returns an integer representation of a date
FL 507 DAYS_BETWEEN scalar function 2	Returns the number of full days between the specified arguments
DBCLOB scalar function	Returns a DBCLOB representation of its argument
DECIMAL or DEC scalar function	Returns a decimal representation of its argument
DECFLOAT scalar function	Returns a DECFLOAT representation of its argument
DECFLOAT_FORMAT scalar function	Returns a DECFLOAT(34) value that is based on the interpretation of the input string using the specified format
DECFLOAT_SORTKEY scalar function	Returns a binary value that can be used when sorting DECFLOAT values
DECODE scalar function	Returns a specified result-expression based on a comparison of input expressions (similar to the CASE expression)
DECRYPT_BINARY, DECRYPT_BIT, DECRYPT_CHAR, and DECRYPT_DB scalar functions	Returns the decrypted value of an encrypted argument that was encrypted using the ENCRYPT_TDES function
FL 505DECRYPT_DATAKEY_INTEGER, DECRYPT_DATAKEY_BIGINT, DECRYPT_DATAKEY_DECIMAL, DECRYPT_DATAKEY_VARCHAR, DECRYPT_DATAKEY_CLOB, DECRYPT_DATAKEY_VARGRAPHIC, DECRYPT_DATAKEY_DBCLOB, and DECRYPT_DATAKEY_BIT scalar functions	Returns the decrypted value of an encrypted argument that was encrypted using the algorithm that was specified when the data was encrypted
DEGREES scalar function	Returns the number of degrees for an argument that is expressed in radians
DIFFERENCE scalar function	Returns a value that represents the difference between the sounds of two strings based on applying the SOUNDEX function to the strings
DIGITS scalar function	Returns a character string representation of a number
DOUBLE_PRECISION or DOUBLE scalar function	Returns a double precision floating-point representation of its argument
DSN_XMLVALIDATE scalar function	Returns an XML value that is the result of applying XML schema validation to the first argument
EBCDIC_CHR scalar function	Returns the character that corresponds to the EBCDIC code value that is specified by the argument
EBCDIC_STR scalar function	Returns an EBCDIC version of the string argument
FL 505 ENCRYPT_DATAKEY scalar function	Returns the argument as an encrypted value using the specified key label and algorithm
ENCRYPT_TDES or ENCRYPT scalar function	Returns the argument as an encrypted value using the Triple DES encryption algorithm
EXP scalar function	Returns the exponential function of an argument
EXTRACT scalar function	Returns a portion of a date or timestamp based on its arguments
FL 504 FIRST_VALUE2	Returns the expression value for the first row in an OLAP window
FLOAT scalar function	Same as DOUBLE
FLOOR scalar function	Returns the largest integer that is less than or equal to the argument
GENERATE_UNIQUE and GENERATE_UNIQUE_BINARY scalar functions	Returns a character string of bit data that is unique compared to any other execution of the function
GETHINT scalar function	Returns the embedded password hint from encrypted data, if one exists
GETVARIABLE scalar function	Returns a varying-length character string representation of the value of a session variable
GRAPHIC scalar function	Returns a fixed-length graphic string representation of its argument
GREATEST scalar function	Returns the maximum value in a set of values
GROUPING aggregate function	Returns a value that indicates if a row returned in a GROUP BY result is a row generated by a grouping set that excludes the column represented by its argument
FL 506 HASH scalar function	Returns a varying-length value that is the result of applying the specified algorithm to the first argument. It is intended for cryptographic purposes.
HASH_CRC32, HASH_MD5, HASH_SHA1, and HASH_SHA256 scalar functions	Return a fixed-length value that is the result of applying a hash algorithm to an input argument. They are intended for cryptographic purposes.
FL 506 HEX scalar function	Returns a hexadecimal representation of its argument
HOUR scalar function	Returns the hour part of its argument
IDENTITY_VAL_LOCAL scalar function	Returns the most recently assigned value for an identity column
IFNULL scalar function	Returns the first argument in a set of two arguments that is not null
INSERT scalar function	Returns a string that is composed of an argument inserted into another argument at the same position where some number of bytes have been deleted
INSTR scalar function	Returns the starting position of the first occurrence of one string within another string
INTEGER or INT scalar function	Returns an integer representation of its argument
JSON_LEN scalar function	Returns the number of elements in an element of type array inside a JSON document. NULL is returned if an element is not an array.
JSON_TABLE table function	Returns a table with two columns. First column is the BSON type and second column is the string value.
JSON_TYPE scalar function	Returns the BSON type of the given element.
JSON_VAL scalar function	Returns an element of a JSON document that is identified by the JSON field name that is specified in search-string. The value of the JSON element is returned in the data type and length that is specified in result-type.
JSON2BSON scalar function	Converts the specified JSON document in string format to an equivalent binary representation in BSON format.
JULIAN_DAY	Returns an integer that represents the number of days from January 1, 4712 B.C.
FL 504 LAG2	Returns the expression value for the row at offset rows before the current row
LAST_DAY scalar function	Returns a date that represents the last day of the month of the date argument
FL 504 LAST_VALUE2	Returns the expression value for the last row in an OLAP window
LCASE scalar function	Returns a string with the characters converted to lowercase
FL 504 LEAD2	Returns the expression value for the row at offset rows after the current row
LEAST scalar function	Returns the minimum value in a set of values
LEFT or STRLEFT scalar function	Returns a string that consists of the specified number of most bytes or the specified string units
LENGTH scalar function	Returns the length of its argument
LN scalar function	Returns the natural logarithm of an argument
LOCATE scalar function	Returns the starting position of one string within another string
LOCATE_IN_STRING scalar function	Returns the starting position of the first occurrence of one string within another string
LOG10 scalar function	Returns the base 10 logarithm of an argument
LOWER scalar function	Returns a string with the characters converted to lowercase
LPAD scalar function	Returns a string that is padded on the with blanks or a specified string
LTRIM scalar function	Returns the characters of a string with the leading blanks or hexadecimal zeros removed
MAX aggregate function	Returns the maximum value in a set of column values in a group
MAX scalar function	Returns the maximum value in a set of values
MAX_CARDINALITY scalar function	Returns a value of type BIGINT that represents the maximum number of elements that an array can contain. This value is the cardinality that was specified in the CREATE TYPE statement for an ordinary array type.
MICROSECOND scalar function	Returns the microsecond part of its argument
MIDNIGHT_SECONDS scalar function	Returns an integer in the range 0–86400 that represents the number of seconds between midnight and the argument
MIN aggregate function	Returns the minimum value in a set of values in a group
MIN scalar function	Returns the minimum value in a set of values
MINUTE scalar function	Returns the minute part of its argument
MOD scalar function	Returns the remainder of one argument divided by a second argument
MONTH scalar function	Returns the month part of its argument
MONTHS_BETWEEN scalar function	Returns an estimate of the number of months between two arguments
MQREAD scalar function 1	Returns a message from a specified IBM® MQ location (return value of VARCHAR) without removing the message from the queue
MQREADALL table function 1	Returns a table containing the messages and message metadata from a specified IBM MQ location with a VARCHAR column and without removing the messages from the queue
MQREADALLCLOB table function 1	Returns a table containing the messages and message metadata from a specified IBM MQ location with a CLOB column and without removing the messages from the queue
MQREADCLOB scalar function 1	Returns a message from a specified IBM MQ location (return value of CLOB) without removing the message from the queue
MQRECEIVE scalar function 1	Returns a message from a specified IBM MQ location (return value of VARCHAR) with removal of message from the queue
MQRECEIVEALL table function 1	Returns a table containing the messages and message metadata from a specified IBM MQ location with a VARCHAR column and with removal of messages from the queue
MQRECEIVEALLCLOB table function 1	Returns a table containing the messages and message metadata from a specified IBM MQ location with a CLOB column and with removal of messages from the queue
MQRECEIVECLOB scalar function 1	Returns a message from a specified IBM MQ location (return value of CLOB) with removal of message from the queue
MQSEND scalar function 1	Sends data to a specified IBM MQ location, and returns a varying-length character string that indicates whether the function was successful or unsuccessful
MULTIPLY_ALT scalar function	Returns the product of the two arguments as a decimal value, used when the sum of the argument precisions exceeds 31
NEXT_DAY scalar function	Returns a timestamp that represents the first weekday, specified by the second argument, after the date argument
FL 507 NEXT_MONTH scalar function 2	Returns the first day of the next month after the specified date
NORMALIZE_DECFLOAT scalar function	Returns a DECFLOAT value that is the result of normalizing the input argument
NORMALIZE_STRING scalar function	Returns a string value that is the result of normalizing the input Unicode value
FL 504 NTH_VALUE 2	Returns the expression value for the nth-row row in an OLAP window
FL 504 NTILE 2	Returns the quantile rank of a row
NULLIF scalar function	Returns NULL if the arguments are equal; else the first argument
NVL scalar function	Returns the first argument that is not null
OVERLAY scalar function	Returns a string that is composed of an argument inserted into another argument at the same position where some number of bytes have been deleted
PACK scalar function	Returns a binary string value that contains a data type array and a packed representation of each non-null argument
PERCENTILE_DISC aggregate function	Returns a percentile of a set of values
FL 504 PERCENT_RANK 2	Returns a relative percentile rank of a row in an OLAP window
FL 504 PERCENT_RANK aggregate function2	Returns the relative percentile rank of a row that is hypothetically inserted into a group of rows
POSITION scalar function	Returns the position of the first occurrence of an argument within another argument where the position is expressed in terms of the string units that are specified
POSSTR or STRPOS scalar function	Returns the position of the first occurrence of an argument within another argument
FL 506 POWER or POW scalar function	Returns the value of one argument raised to the power of a second argument
QUANTIZE scalar function	Returns a DECFLOAT value that is equal in value (except for any rounding) and sign to the first argument and which has an exponent set to be equal to the exponent of the second argument
QUARTER scalar function	Returns an integer in the range 1–4 that represents the quarter of the year for the date specified in the argument
RADIANS scalar function	Returns the number of radians for an argument that is expressed in degrees
RAISE_ERROR scalar function	Raises an error in the SQLCA with the specified SQLSTATE and error description
FL 506 RANDOM or RAND scalar function	Returns a double precision floating-point random number
FL 504 RATIO_TO_REPORT 2	Returns the ratio of an argument to the sum of the arguments in an OLAP partition
REAL scalar function	Returns a single precision floating-point representation of its argument
FL 504 REGEXP_COUNT scalar function 2	Returns a count of the number of times that a regular expression pattern is matched in a string
FL 504 REGEXP_INSTR scalar function2	Returns the starting or ending position of the matched substring, depending on the value of the return_option argument
FL 504 REGEXP_LIKE scalar function2	Returns an INTEGER value of 0 or 1 indicating if the regular expression pattern is found in a string
FL 504 REGEXP_REPLACE scalar function2	Returns a modified version of the source string where occurrences of the regular expression pattern found in the source string are replaced with the specified replacement string
FL 504 REGEXP_SUBSTR scalar function2	Returns one occurrence of a substring of a string that matches the regular expression pattern
FL 507 REGR_AVGX, REGR_AVGY, REGR_SXX, REGR_SXY, and REGR_SYY2	Return quantities that can be used to compute various diagnostic statistics needed for the evaluation of the quality and statistical validity of a regression model
FL 507 REGR_COUNT2	Returns the number of non-null number pairs used to fit a regression line
FL 507 REGR_INTERCEPT or REGR_ICPT2	Returns the y-intercept of a regression line ("b" in the equation y = a * x + b)
FL 507 REGR_R22	Returns the coefficient of determination ("R-squared" or "goodness-of-fit") for a regression
FL 507 REGR_SLOPE2	Returns the slope of a regression line ("a" in the equation y = a * x + b)
REPEAT scalar function	Returns a character string composed of an argument repeated a specified number of times
REPLACE scalar function	Returns a string in which all occurrences of an argument within a second argument are replaced with a third argument
RID scalar function	Returns the RID of a row
RIGHT or STRRIGHT scalar function	Returns a string that consists of the specified number of rightmost bytes or specified string units
ROUND scalar function	Returns a number rounded to the specified number of places to the right or of the decimal place
ROUND_TIMESTAMP scalar function	Returns a timestamp rounded to the unit specified by the timestamp format string
ROWID scalar function	Returns a row ID representation of its argument
RPAD scalar function	Returns a string that is padded on the right with blanks or a specified string
RTRIM scalar function	Returns the characters of an argument with the trailing blanks or hexadecimal zeros removed
SCORE scalar function	Returns a relevance score that measures how well a document matches the query used to search a text search index
SECOND scalar function	Returns the second part of its argument
SIGN scalar function	Returns the sign of an argument
SIN scalar function	Returns the sine of an argument that is expressed as an angle in radians
SINH scalar function	Returns the hyperbolic sine of an argument that is expressed as an angle in radians
SMALLINT scalar function	Returns a small integer representation of its argument
SOAPHTTPC and SOAPHTTPV scalar functions (deprecated)	Returns a CLOB or VARCHAR representation of XML data from a request to a web service
SOAPHTTPNC and SOAPHTTPNV scalar function	Returns a complete CLOB or VARCHAR representation of XML data from a complete request to a web service
SOUNDEX scalar function	Returns a value that represents the sound of the words in the argument
SPACE scalar function	Returns a string that consists of the number of blanks the argument specifies
SQRT scalar function	Returns the square root of its argument
STDDEV_POP or STDDEV aggregate function	Returns the population standard deviation (division by n) of a set of numbers
STDDEV_SAMP aggregate function	Returns the sample standard deviation (division by n-1) of a set of numbers
STRIP scalar function	Returns the characters of a string with the blanks (or specified character) at the beginning, end, or both beginning and end of the string removed
FL 506 STRLEFT scalar function	Returns a string that consists of the specified number of most bytes or the specified string units
FL 506 STRPOS scalar function	Returns the position of the first occurrence of an argument within another argument
FL 506 STRRIGHT scalar function	Returns a string that consists of the specified number of rightmost bytes or specified string units
SUBSTR scalar function	Returns a substring of a string
SUBSTRING scalar function	Returns a substring of a string using the specified string units
SUM aggregate function	Returns the sum of a set of numbers
TAN scalar function	Returns the tangent of an argument that is expressed as an angle in radians
TANH scalar function	Returns the hyperbolic tangent of an argument that is expressed as an angle in radians
TIME scalar function	Returns a time derived from its argument
TIMESTAMP scalar function	Returns a timestamp derived from its arguments
TIMESTAMPADD scalar function	Returns a timestamp derived from adding the specified interval to a timestamp
TIMESTAMP_FORMAT or TO_TIMESTAMP scalar function	Returns a timestamp for a character string expression, using a specified format to interpret the string
TIMESTAMP_ISO scalar function	Returns a timestamp derived from its arguments
TIMESTAMPDIFF scalar function	Returns an estimated number of the specified intervals based on the difference between two timestamps
TIMESTAMP_TZ scalar function	Returns a timestamp with a time zone derived from its arguments
TO_CHAR scalar function	Returns a character string representation of a timestamp value that has been formatted using a specified character template
FL 506 TO_CLOB scalar function	Returns a CLOB representation of the first argument
TO_DATE scalar function	Returns a timestamp value that is based on the interpretation of the input string using the specified format
TO_NUMBER scalar function	Returns a DECFLOAT(34) value that is based on the interpretation of the input string using the specified format
TOTALORDER scalar function	Returns a SMALLINT value that indicates the comparison order of two arguments
FL 506 TO_TIMESTAMP scalar function	Returns a timestamp for a character string expression, using a specified format to interpret the string
TRANSLATE scalar function	Returns a string with one or more characters translated
TRIM scalar function	Removes bytes from the beginning, from the end, or from both the beginning and end of a string expression
TRIM_ARRAY scalar function	Returns an array after removing elements from the end of an ordinary array.
TRUNCATE or TRUNC scalar function	Returns a number truncated to the specified number of places to the right or of the decimal point
TRUNC_TIMESTAMP scalar function	Returns a timestamp truncated to the unit specified by the timestamp format string
UCASE scalar function	Returns a string with the characters converted to uppercase
UNICODE scalar function	Returns the Unicode (UTF-16) code value of the most character of the argument as an integer
UNICODE_STR or UNISTR scalar function	Returns a string in Unicode (UTF-8 or UTF-16) that represents a Unicode encoding of the argument
UNPACK row function	Returns a row of values that are derived from unpacking the input binary string. It is used to unpack a string that was encoded according to the PACK function
UPPER scalar function	Returns a string with the characters converted to uppercase
VALUE scalar function	Same as COALESCE
VARBINARY scalar function	Returns a varying-length binary string representation of its argument
VARCHAR scalar function	Returns the varying-length character string representation of its argument
VARCHAR9 scalar function	Returns the fixed-length character string representation of its argument
VARCHAR_FORMAT scalar function	Returns a varying-length character string representation of a timestamp, with the string in a specified format
VARGRAPHIC scalar function	Returns a varying-length graphic string representation of its argument
VAR_POP or VARIANCE or VAR aggregate function	Returns the biased variance (division by n) of a set of numbers
VAR_SAMP or VARIANCE_SAMP aggregate function	Returns the sample variance (division by n-1) of a set of numbers
VERIFY_GROUP_FOR_USER scalar function	Returns a value that indicates whether the primary authorization ID and the group authorization IDs that are associated with the first argument are included in the authorization names that are specified in the list of the second argument.
VERIFY_ROLE_FOR_USER scalar function	Returns a value that indicates whether the roles that are associated with the first argument are included in the role names that are specified in the list of the second argument
VERIFY_TRUSTED_CONTEXT_ROLE_FOR_USER scalar function	Returns a value that indicates whether the authorization ID that is associated with first argument has acquired a role in a trusted connection and whether that acquired role is included in the role names that are specified in the list of the second argument
WEEK scalar function	Returns an integer that represents the week of the year with Sunday as the first day of the week
WEEK_ISO scalar function	Returns an integer that represents the week of the year with Monday as first day of a week
XMLAGG aggregate function	Returns an XML type that represents a concatenation of XML elements from a collection of XML elements
XMLATTRIBUTES scalar function	Returns an XML sequence that contains an XQuery attribute node for each non-null argument
XMLCOMMENT scalar function	Returns an XML value with a single comment node from a string expression
XMLCONCAT scalar function	Returns an XML value that represents a forest of XML elements generated by concatenating a variable number of arguments
XMLDOCUMENT scalar function	Returns an XML value with a single document node and zero or more nodes as its children
XMLELEMENT scalar function	Returns an XML value that represents an XML element
XMLFOREST scalar function	Returns an XML value that represents a forest of XML elements that all share a specific pattern
XMLMODIFY scalar function	Returns an XML value that might have been modified by the evaluation of an XQuery updating expression and XQuery variables that are specified as input arguments
XMLNAMESPACES scalar function	Returns the declaration of one or more XML namespaces
XMLPARSE scalar function	Returns an XML value from parsing the argument as an XML document
XMLPI scalar function	Returns an XML value with a single processing instruction node
XMLQUERY scalar function	Returns an XML value from the evaluation of an XPath expression against a set of arguments
XMLSERIALIZE scalar function	Returns an SQL character string or a BLOB value from an XML value
XMLTABLE table function	Returns a result table from the evaluation of XQuery expressions, possibly using specified input arguments as XQuery variables
XMLTEXT scalar function	Returns an XML value with a single text node that contains the value of the argument
XMLXSROBJECTID scalar function	Returns the XSR object identifier of the XML schema that is used to validate the XML document specified in the argument
XSLTRANSFORM scalar function 1	The XSLTRANSFORM function transforms an XML document into a different data format. The output can be any form possible for the XSLT processor, including but not limited to XML, HTML, and plain text.
YEAR scalar function	Returns the year part of its argument

Notes:

1. A user-defined function that is supplied with Db2.
2. Supported in Db2 for z/OS as a passthrough-only expression, which is passed through to IBM Db2 Analytics Accelerator for z/OS. For more information, see Accelerating queries with passthrough-only expressions.