Scalar Functions in Db2 12
(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)
>__ABS(numeric-expression)________________________________________________>
>__ACOS(numeric-expression)_______________________________________________>
>__ADD_MONTHS(expression,numeric-expression)______________________________>
>__ARRAY_DELETE(array-expression___________________________________)______>
ǀ_,_array-index1_________________ǀ
ǀ_,ǀ_array-index2_ǀ
>__ARRAY_FIRST(array-expression___________________________________________>
>__ARRAY_LAST(array-expression____________________________________________>
>__ARRAY_FIRST(array-expression, array-index)_____________________________>
>__ARRAY_PRIOR(array-expression, array-index)_____________________________>
>_ASCII(string-expression)________________________________________________>
>_ASCII_CHR(expression)___________________________________________________>
>_ASC11_CHR(string-expression)____________________________________________>
>__ASIN(numeric-expression)_______________________________________________>
>__ATAN(numeric-expression)_______________________________________________>
>__ATANH(numeric-expression)_____________________________________________>
>__ATAN2(numeric-expression1,numeric-expression2)_________________________>
Numeric to Big Integer:
>_BIGINT(numeric-expression______________________________________________>
String to Big Integer:
>_BIGINT(string-expression_______________________________________________>
>_BINARY(string-expression_________________)_____________________________>
ǀ_,_integer_ǀ
>__BITAND_____(_expression1__, expression2__)____________________________> ǀ_BITANDNOT_ǀ ǀ_BITOR_____ǀ ǀ_BITXOR____ǀ >_BITNOT(_expression_)___________________________________________________>
>__BLOB(expression_______________)_______________________________________>
ǀ_,__integer_ǀ
>__CARDINALITY(array-expression)_________________________________________>
>__CCSID_ENCODING(expression)____________________________________________>
>__CEILING_______(__expression__)________________________________________>
Datetime to Character:
>__CHAR(datetime-expression________________)_____________________________>
ǀ_,____ISO____ǀ
ǀ_USA___ǀ
ǀ_EUR___ǀ
ǀ_JIS___ǀ
ǀ_LOCAL_ǀ
Character to character:
>__CHAR(character-expression_______________________________)_____________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
Graphic to character:
__CHAR(graphic-expression____________________________________)__________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
Integer to character:
>__CHAR(integer-expression)______________________________________________>
Decimal to character:
>__CHAR(decimal-expression)___________________________)__________________>
ǀ_,__decimal-character_ǀ
Decimal floating-Point to Character:
>__CHAR(decimal-floating-point-expression)______________________________>
Floating-Point to Character:
>__CHAR(floating-point-expression)______________________________________>
Row ID to Character:
>__CHAR(row-ID-expression)______________________________________________>
>__CHAR9__(decimal-expression______________________________)____________>
ǀ_,_decimal-character__ǀ
Character sting:
>__CHARACTER_LENGTH(character-expression__,_ CODEUNITS16_____)__________>
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
Graphic string:
>__CHARACTER_LENGTH(graphic-expression__,____CODEUNITS16_____)__________>
ǀ_CODEUNITS32_ǀ
Character to CLOB:
>__CLOB(character-expression___________________________________)________>
ǀ_,_integer_________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
GRAPHIC to CLOB:
>__CLOB(graphic-expression_____________________________________)________>
ǀ_,_integer_________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
<___________ >____COALESCE___(expression__,expressionǀ_)_____________________________>
>__COLLATION_KEY(string-expression, collation-name______________)_______>
ǀ_,integer_ǀ
>__COMPARE_DECFLOAT(decfloat-expression1, decfloat-expression2__________>
>_____CONCAT____(expression1,expression2)_______________________________>
ǀ_"ǀǀ"____ǀ
>__CONTAINS____(column-name, search-argument)___________________________>
ǀ_,string-constant_ǀ
Search-argument-options:
<______________________
>________________________________ǀ______________________________________>
ǀ_QUERYLANGUAGE = value_ǀ
ǀ_RESULTLIMIT = value___ǀ
ǀ _OFF_ ǀ
ǀ_SYNONYM = ǀ_ON__ǀ_____ǀ
>__COS(numeric-expression)_______________________________________________>
>__COSH(numeric-expression)______________________________________________>
>__DATE(expression)______________________________________________________>
>__DAY(expression)_______________________________________________________>
>__DAYOFMONTH(expression)________________________________________________>
>__DAYOFWEEK(expression)_________________________________________________>
>__DAYOFWEEK_ISO(expression)_____________________________________________>
>__DAYOFYEAR(expression)_________________________________________________>
>__DAYS(expression)______________________________________________________>
Character to DBCLOB:
>__DBCLOB(character-expression__________________________________)________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
GRAPHIC to DBCLOB:
>__DBCLOB(graphic-expression____________________________________)________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_,ǀ_CODEUNITS32_ǀ
numeric to DECFLOAT:
_,34_
>__DECFLOAT_(_numeric-expression__ǀ_____ǀ_______________________)________>
ǀ_,16_ǀ
string to DECFLOAT:
_,34_
>__DECFLOAT_(_string-expression__ǀ_____ǀ________________________)________>
ǀ_,16_ǀ
>_____DECFLOAT_FORMAT___(___string-expression_____________________)______>
ǀ_,_format-string_ǀ
>_DECFLOAT_SORTKEY_ (_decfloat-expression_)______________________________>
Numeric to decimal:
>_____DECIMAL___(___numeric-expression_____________________________)_____>
ǀ_DEC_____ǀ ǀ_,precision___________ǀ
ǀ_scale_ǀ
String to decimal:
>_DECIMAL_(string-expression______________________________________)______>
ǀ_DEC__ǀ ǀ_,precision______________________ǀ
ǀ_,scale_____________ǀ
ǀ_,decimal-char_ǀ
<__________________________________
>_DECODE_(_expression1__,_expression2_,_result-expression_ǀ______________>
>________________________________________________________________)_______>
ǀ_,_else-expression_ǀ
>>___ _DECRYPT_BINARY__________(encrypted-data___________________________>
ǀ_DECRYPT_BIT___ǀ
ǀ_DECRYPT_CHAR__ǀ
ǀ_DECRYPT_DB____ǀ
>_____ __________________________________________________________)_______>
ǀ_,_ _password-string___________ _ _ ____________________ǀ
ǀ_DEFAULT___________________ǀ_ǀ_,__ccsid-constant_ǀ
>__DEGREES(expression)___________________________________________________>
>__DIFFERENCE(expression1, expression2)__________________________________>
>__DIGITS(expression)____________________________________________________>
>__DOUBLE__________________(___numeric-expression___)____________________> ǀ_DOUBLE_PRECISION_ǀ ǀ_string-expression__ǀ
>__DSN_XMLVALIDATE_______________________________________________________> >_(string-expression_,_schema-name-string________________________________> ǀ_xml-expression_ǀ ǀtarget-namespace-uri-sting,schema-location-stringǀ
>>__EBCDIC(expression)___________________________________________________>
>>__EBCDIC_STR(string-expression)________________________________________>
>>__ENCRYPT_TDES(data-string____________________________________)________>
ǀ_,password-string,hint-string_ǀ
>__EXP(numeric-expression)_______________________________________________>
Extract date values:
>__EXTRACT(__YEAR____)_FROM__date-expression__________)_________________>
ǀ_MONTH_ǀ ǀ_timestamp-expression_ǀ
ǀ_DAY___ǀ
Extract time values:
>__EXTRACT(___HOUR____)_FROM__time-expression__________)________________>
ǀ_MINUTE_ǀ ǀ_timestamp-expression_ǀ
ǀ_SECOND_ǀ
Extract time zone values:
>__EXTRACT(___HOUR____)________FROM__date-expression___________)________>
ǀ_MINUTE__________ǀ ǀ_time-expression_______ǀ
ǀ_SECOND__________ǀ ǀ_timestamp-expression__ǀ
ǀ_TIMEZONE_HOUR___ǀ
ǀ_TIMEZONE_MINUTE_ǀ
>__FLOAT(numeric-expression)____________________________________________>
>__LOWER(string-expression____________________________________)_________>
ǀ_,_locale-name_ǀ ǀ_,_integer_ǀ
>__LPAD(string-expression,integer______________)________________________>
ǀ_,_pad_ǀ
>__LTRIM(string-expression)______________________________)______________>
ǀ_,_trim-expression_ǀ
<___________ >__MAX(expression, expression1_ǀ_)______________________________________>
>__MAX_CARDINALITY(array-expression)____________________________________>
>__MICROSECOND(expression)______________________________________________>
>__MIDNIGHT_SECONDS(expression)_________________________________________>
<__________ >__MIN(expression, expression_ǀ_)_______________________________________>
>__MINUTE(expression)___________________________________________________>
>__MOD(numeric-expression1,numeric-expression2)_________________________>
>__MONTH(expression)____________________________________________________>
>__MONTHS_BETWEEN(expression1, expression2)_____________________________>
>__MULTIPLY_ALT(exact-numeric-expression1,exact-numeric-expression2)____>
>__NEXT_DAY(expression,string-expression)_______________________________>
>__NORMALIZE_DECFLOAT(decfloat-expression)______________________________>
_NFC__
>__NORMALIZE_STRING(Unicode-string,_ǀ_NFD__ǀ________________)___________>
ǀ_NFKC_ǀ ǀ_,_integer_ǀ
ǀ_NKFD_ǀ
>__NULLIF(expression,expression)________________________________________>
<__________ >__NVL(expression, expression_ǀ_)_______________________________________>
>_OVERLAY(source-string_,insert-string_,_length_,_CODEUNITS16____)______>
ǀ_CODEUNTIS32_ǀ
ǀ_OCTETS______ǀ
<__________
>__PACK(___CCSID 1208_____,_expression_ǀ_)______________________________>
ǀ_CCSID DEFAULT_ǀ
>_POSTION(search-string,source-string_,_ CODEUNITS16__)_________________>
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
>__POSSTR(source-string, search-string)_________________________________>
>__POWER(numeric-expression1,numeric-expression2)_______________________>
>__QUANTIZE(expression-1,expression-2)__________________________________>
>__QUARTER(expression)__________________________________________________>
>__RADIANS(numeric-expression)__________________________________________>
>__RAISE_ERROR(sqlstate,diagnostic-string)______________________________>
>__RAND(_________________________)______________________________________>
ǀ_numeric-expression_ǀ
>__REAL(____numeric-expression___)______________________________________>
ǀ_string-expression__ǀ
>__FLOOR(numeric-expression)____________________________________________>
>__GENERATE_UNIQUE()____________________________________________________> ǀ_GENERATE UNIQUE BINARY()_ǀ
>__GETHINT(encrypted-data)______________________________________________>
>__GETVARIABLE(string-constant_ ________________________________________>
ǀ_,__default-value________________ǀ
ǀ_,__CAST_(_NULL_AS_VARCHAR(1)_)__ǀ
Character to Graphic:
>__GRAPHIC(character-expression____________________________________)_______>
ǀ_,_integer______________________ǀ
ǀ_,_CODEUNITS16____ǀ
ǀ_CODEUNITS32_ǀ
Graphic to Graphic:
>__GRAPHIC(graphic-expression___________________________________)_______>
ǀ_,_integer__________________ǀ
ǀ_,_CODEUNITS16___ǀ
ǀ_CODEUNITS32_ǀ
>__HASH_CRC32_____(expression)__________________________________________> ǀ_HASH_MD5______ǀ ǀ_HASH_SHA1_____ǀ ǀ_HASH_SHA256___ǀ
>__HEX(expression)______________________________________________________>
>__HOUR(expression)_____________________________________________________>
>__IDENTITY_VAL_LOCAL()_________________________________________________>
>__IFNULL(expression,expression)________________________________________>
>_INSERT(source-string),start,length,insert-string____________________)___>
ǀ_,_CODEUNITS16___ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
>_____INTEGER___(___numeric-expression___)________________________________>
ǀ_INT_____ǀ ǀ_string-expression__ǀ
>__JULIAN_DAY(expression)_________________________________________________>
>__LAST_DAY(expression)___________________________________________________>
>____LCASE___(string-expression)__________________________________________>
ǀ,_locale-name_ǀ ǀ_,_integer_ǀ
Character string:
>_LEFT(character-expression,length____________________)___________________>
ǀ_,_CODEUNITS16__ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
Graphic string:
>_LEFT(graphic-expression,length_____________________)____________________>
ǀ_,_CODEUNITS16__ǀ
ǀ_CODEUNITS32_ǀ
Binary string:
>_LEFT(binary-expression,length______________________)____________________>
>__LENGTH(expression)_____________________________________________________>
>__LN(numeric-expression)_________________________________________________>
>_LOCATE(search-string,source-string_________________)____________________>
ǀ_,_start_ǀ ǀ_,_CODEUNITS16___ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
>_LOCATE(source-string,search-string______________________________________>
ǀ_,_start________________ǀ
ǀ_,instance_ǀ
>_____________________________________________________)___________________><
ǀ_,_CODEUNITS16__ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
>__LOG10(numeric-expression)______________________________________________>
>__REPEAT(expression,integer)_____________________________________________>
>__REPLACE(source-string, search-string, replace-string)__________________>
>__RID(table-designator)__________________________________________________>
>__RIGHT(string-expression,length)_______________________________________>
ǀ_,_CODEUNITS16___ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
_,_0___________________
>__ROUND(numeric-expression1,_ǀ_______________________ǀ_)________________>
ǀ_,_numeric-expression2_ǀ
_,_’DD’_________
>__ROUND_TIMESTAMP(_expression_ǀ________________ǀ_)______________________>
ǀ_,format-string_ǀ
>__ROWID(expression)_____________________________________________________>
>__RPAD(string-expression,integer____________)___________________________>
ǀ_,_pad_ǀ
>__RTRIM(string-expression_______________________)_______________________>
ǀ_,_trim-expression_ǀ
>__SCORE(column-name, search-argument, string-constant)__________________>
Search-argument-options:
<______________________
>____________________________ǀ___________________________________________>
ǀ_QUERYLANGUAGE = value_ǀ
ǀ_RESULTLIMIT = value___ǀ
ǀ _OFF_ ǀ
ǀ_SYNONYM = ǀ_ON__ǀ_____ǀ
>__SECOND(expression)____________________________________________________>
ǀ_,integer-constant_ǀ
>__SIGN(numeric-expression)______________________________________________>
>__SIN(numeric-expression)_______________________________________________>
>__SINH(numeric-expression)______________________________________________>
>__SMALLINT(___numeric-expression___)____________________________________>
ǀ_string-expression__ǀ
>__SOUNDEX(expression)___________________________________________________>
>__SOAPHTTPC___(endpoint_url, soap_action, soap_body)____________________> ǀ_SOAPHTTPV_ǀ
>__SPACE(numeric-expression)_____________________________________________>
>__SQRT(numeric-expression)______________________________________________>
>__STRIP_(_string-expression___________________________________________)_>
ǀ___,BOTH_____________________________ǀ
ǀ_,B________ǀ ǀ_,strip-character_ǀ
ǀ_,LEADING__ǀ
ǀ_,L________ǀ
ǀ_,TRAILING_ǀ
ǀ_,T________ǀ
>__SUBSTR(string-expression,start______________)_________________________>
ǀ_,length_ǀ
Character:
>_SUBSTRING(character-expression,start,___________,_CODEUNITS16____)_____>
ǀ_,length_ǀ ǀ_CODEUNITS32_ǀ
ǀ__OCTETS_____ǀ
Graphic:
>_SUBSTRING(graphic-expression,start,____________,_CODEUNITS16____)______>
ǀ_,length_ǀ ǀ_CODEUNITS32_ǀ
Binary:
>_SUBSTRING(binary-expression,start,_____________)_______________________>
ǀ_,length_ǀ
>__TAN(numeric-expression)_______________________________________________>
>__TANH(numeric-expression)______________________________________________>
>__TIME(expression)______________________________________________________>
>__TIMESTAMP(expression)_________________)_______________________________>
ǀ_,expression_ǀ
>__TIMESTAMPADD(interval, number, expression)____________________________>
>__TIMESTAMP_FORMAT(string-expression,format-string______________________>
_,6________________________
>__ǀ___________________________ǀ______)__________________________________>
ǀ_,_precision-constant______ǀ
>_TIMESTAMP_ISO(expression)______________________________________________>
>__TIMESTAMPDIFF(numeric-expression,string-expression)___________________>
>_TIMESTAMP_TZ(expression1)______________________________________________>
ǀ_,expression2_ǀ
>__TO_CHAR(string-expression,format-string)______________________________>
>__TO_DATE(string-expression,format-string)______________________________>
_,6_______________________
>__ǀ__________________________ǀ_______)__________________________________>
ǀ_,_precision-constant_____ǀ
>_TO_NUMBER(string-expression)______________________)____________________>
ǀ_,_format string_ǀ
>__TOTALORDER(expression1, expression2)__________________________________>
>_TRANSLATE(expression_____________________________________________)_____>
ǀ_,_to-string_______________________________________ǀ
ǀ _,__’ ‘___________ ǀ
ǀ_,__from-string_ǀ__________________ǀ_ǀ
ǀ_,__pad-character_ǀ
>__TRIM_(_string-expression____________________________________________)_>
ǀ___,BOTH__________________________FROM_ǀ
ǀ_,B________ǀ ǀ_,trim-constant_ǀ
ǀ_,LEADING__ǀ
ǀ_,L________ǀ
ǀ_,TRAILING_ǀ
ǀ_,T________ǀ
>______TRIM_ARRAY___(array-expression, numeric-expression_)_____________>
ǀ_ARRAY_TRIM__ǀ
_,_0___________________ >__TRUNCATE_(numeric-expression1_ǀ_______________________ǀ_)____________> ǀ__TRUNC__ǀ ǀ_,numeric expression2__ǀ
_’DD’___________
>__TRUNC_TIMESTAMP_(expression1_ǀ________________ǀ_)____________________>
ǀ_,format-string_ǀ
>____UCASE___(string-expression_________________________________)_______>
ǀ_,_locale-name_ǀ ǀ_,-integer_ǀ
>____UNICODE___(string-expression)______________________________________>
_,UTF-8_
>____UNICODE_STR_(string-expression)_ǀ________ǀ_)________________________>
ǀ_,UTF16_ǀ
>____UPPER___(string-expression_________________________________)________>
ǀ_,_locale-name_ǀ ǀ_,_integer_ǀ
<____________ >____VALUE_(expression_, expression_ǀ_)__________________________________>
>__VARCHAR(string-expression______________)______________________________>
ǀ_,__integer_ǀ
Varchar to Character:
>__VARCHAR(character-expression_______________________________)__________>
ǀ_,_integer_________________ǀ
ǀ_,_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
ǀ_Octets_ǀ
Graphic to Varchar:
>__VARCHAR(graphic-expression___________________________________)__________> ǀ_,_integer__________________ǀ ǀ_,_CODEUNITS16_ǀ ǀ_CODEUNITS32_ǀ
Datetime to Varchar:
>__VARCHAR(datetime-expression)____________________________________________>
Integer to Varchar:
>__VARCHAR(integer-expression)_____________________________________________>
Decimal to Varchar:
>__VARCHAR(decimal-expression)_____________________________)_______________> ǀ_,__decimal-character_ǀ
Decimal floating-Point to Varchar:
>__VARCHAR(decimal-floating-point-expression)______________________________>
Floating-Point to Varchar:
>__VARCHAR(floating-point-expression)______________________________________>
Row ID to Varchar:
>__VARCHAR(row-ID-expression)______________________________________________>
>__VARCHAR_BIT_FORMAT(expression,format-string)____________________________>
>__VARCHAR9(decimal-expression__________________________________)__________> ǀ_,_decimal-character_____ǀ
Character to VARCHAR:
>__VARCHAR_FORMAT(character-expression)____________________________________>
Timestamp to VARCHAR:
>__VARCHAR_FORMAT(timestamp-expression,format-string)______________________>
Decimal floating-point to VARCHAR:
>__VARCHAR_FORMAT(decimal-floating-point-expression,format-string)_________>
Character to Vargraphic:
>__VARGRAPHIC(character-expression____________________________)________> ǀ_,_integer____________ǀ ǀ_,_CODEUNITS16__ǀ ǀ__CODEUNITS32_ǀ
Graphic to Vargraphic:
>__VARGRAPHIC(graphic-expression_____________________________)_________> ǀ_,_integer____________ǀ ǀ_,_CODEUNITS16__ǀ ǀ__CODEUNITS32_ǀ
<_,_________ >__VERIFY_GROUP_FOR_USER_(_SESSION_USER__,_group-name-expression_ǀ_)______> ǀ_USER_______ǀ
<_,________ >__VERIFY_ROLE_FOR_USER_(_SESSION_ROLE__,_role-name-expression_ǀ_)________> ǀ_USER_______ǀ
>__WEEK(expression)_______________________________________________________>
>__WEEK_ISO(expression)___________________________________________________>
>__WRAP(object-definition-string)_________________________________________>
<_,______________________________________________ >__XMLATTRIBUTES(_attribute-value-expression________________________ǀ_____> ǀ_AS_attribute-name_ǀ
>__XML2COMMENT(string-expression)_________________________________________>
<_________________ >__XMLCONCAT(XML-expression_____,__XML-expression_ǀ_)_____________________>
>__XMLDOCUMENT(XML-expression)____________________________________________>
>__XMLELEMENT(_NAME__ element-name________________________________________>
ǀ_,_xmlnamespace-declaration_ǀ
<_______________________________
>_________________________________________________________________ǀ_______>
ǀ,_XML-attributes-function_ǀ ǀ_,_element-content-expression_ǀ
>_________________________________________________________________________>
ǀ ǀ
ǀ <___________________________________ ǀ
ǀ _EMPTY ON NULL_ ǀ ǀ
ǀ_OPTION___ǀ_NULL ON NULL__ǀ_________________ ǀ__ǀ
ǀ _USING_ ǀ
ǀ__XMLBINARY__ǀ_______ǀ_BASE64______ǀ
ǀ | _USING_ | ǀ
ǀ |_XMLBINARY_| |_HEX________|_ǀ
>_XMLFOREST(_ ___________________________________________________________>
ǀ_XMLnamespace-function_,_ǀ
<__,____________________________________________
>_ element-content-expression_____________________ǀ______________________>
ǀ_AS_element-name_ǀ
>________________________________________________________________________>
ǀ <__________________________________ ǀ
ǀ _EMPTY ON NULL_ ǀ ǀ
ǀ_OPTION_____ǀ_NULL ON NULL__ǀ______________ ǀ____ǀ
ǀ _USING_ ǀ
ǀ _XMLBINARY__ǀ______ǀ_BASE64__ ǀ
ǀǀ _USING_ ǀ ǀ
ǀǀ_XMLBINARY__ǀ______ǀ_HEX_____ǀ_ǀ
>__XMLMODIFY(__xquery-update-constant_____________________________)______>
ǀ <_________________________________________ ǀ
ǀ_,___xquery-variable-expression_AS_identifier ǀ_ǀ
<_,__________________________________
>__XMLNAMESPACES(__namespace-uri_AS_namespace-prefix__ǀ_)________________>
ǀ_DEFAULT_XML-namespace-uri________ǀ
ǀ_NO DEFAULT_____________ǀ
_STRIP WHITESPACE_______
>_XMLPARSE(DOCUMENT_string-expression___ǀ________________________ǀ_)_____>
ǀ_XML-host-variable_ǀ ǀ_PRESERVE WHITESPACE_ǀ
>_XMLPI(NAME_pi-name________________________________)____________________>
ǀ_,_string-expression_ǀ
>_XMLQUERY(xquery-expression-constant)____________________________________>
ǀ _BY REF_ ǀ
ǀ_PASSING_ǀ_______ǀ_xquery-argument_ǀ
_BY REF_
_RETURNING SEQUENCE_ǀ________ǀ_ _EMPTY ON EMPTY_
>_ǀ_______________________________ǀ_ǀ________________ǀ__)_________________>
Xquery-argument:
>____xquery-context-item-expression_______________________________________> ǀ_xquery-variable-expression AS identifier__ǀ
_CONTENT_
>_XMLSERIALIZE(_ǀ_________ǀ_XML-expression AS data-type___________________>
<_____________________________________
_VERSION__’1.0’__________________ ǀ
>__ǀ_________________________________ǀ___ǀ________________________________>
ǀ _EXCLUDING XMLDECLARATION__ ǀ
ǀ_ǀ_INCLUDING XMLDECLARATION__ǀ___ǀ
data-type:
_(_1M_)___________ >______CHARACTER______LARGE OBJECT_____ǀ__________________ǀ_______________> ǀ ǀ ǀ_CHAR_______ǀ ǀ ǀ ǀ_(__integer_____)_ǀ ǀ ǀ_CLOB_________________________ǀ ǀ ǀ_K_ǀ ǀ_DCLOB____________________________ǀ ǀ_M_ǀ ǀ__BINARY LARGE OBJECT_____________ǀ ǀ_G_ǀ ǀ_BLOB________________ǀ
>_XMLTEXT(_string-expression______________________)_______________________>
>_XMLXSROBJECTID(_xml-value-expression __)________________________________>
>_XSLTRANSFORM(_xml-document, xsl-stylesheet, xsl-parameters)_____________>
>_YEAR(expression)________________________________________________________>
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.