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.
| 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 |
| 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 |
 AI_ANALOGY scalar function |
Computes an analogy score between two sets of values. |
| AI_COMMONALITY scalar function |
Computes a similarity score by using the value of the expression argument and the centroid value of the model column. |
| AI_SEMANTIC_CLUSTER scalar function |
Computes a semantic clustering score of a member argument against a set of clustering arguments. |
| AI_SIMILARITY scalar function |
Computes a similarity score between two values. |
| 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. |
| 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 |
| CHARACTER_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 |
| 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 |
| CUME_DIST 2 | Returns a cumulative distribution of a row in an OLAP window |
| 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 |
| 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 |
| DECRYPT_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 |
| 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 |
| 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 |
| 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. |
| 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 |
| FL 505 INTERPRET scalar function |
Returns a representation of its argument in the specified data type |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| NTH_VALUE 2 | Returns the expression value for the nth-row row in an OLAP window |
| 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 |
| PERCENT_RANK 2 | Returns a relative percentile rank of a row in an OLAP window |
| 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 |
| 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 |
| RANDOM or RAND scalar function | Returns a double precision floating-point random number |
| 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 |
| REGEXP_COUNT scalar function 2 | Returns a count of the number of times that a regular expression pattern is matched in a string |
| REGEXP_INSTR scalar function2 | Returns the starting or ending position of the matched substring, depending on the value of the return_option argument |
| REGEXP_LIKE scalar function2 | Returns an INTEGER value of 0 or 1 indicating if the regular expression pattern is found in a string |
| 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 |
| REGEXP_SUBSTR scalar function2 | Returns one occurrence of a substring of a string that matches the regular expression pattern |
| 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 |
| REGR_COUNT2 | Returns the number of non-null number pairs used to fit a regression line |
| REGR_INTERCEPT or REGR_ICPT2 | Returns the y-intercept of a regression line ("b" in the equation y = a * x + b) |
| REGR_R22 | Returns the coefficient of determination ("R-squared" or "goodness-of-fit") for a regression |
| 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 |
| STRLEFT scalar function | Returns a string that consists of the specified number of most bytes or the specified string units |
| STRPOS scalar function | Returns the position of the first occurrence of an argument within another argument |
| 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 |
| 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 |
| 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:
- A user-defined function that is supplied with Db2.
- 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.