ポイント: Db2 12のスカラー関数は、データ操作と取得のための重要なツールでSQLクエリを強化し、構文例を含むさまざまなスカラー関数をカバーしています。
- 関数にはABS、ACOS、ADD_MONTHSなどが含まれています。
- 各関数にはユーザーのガイダンスのために詳細な例が付随しています。
>__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)_________________________>
>_BIGINT(numeric-expression______________________________________________>
文字列からビッグ整数へ:
>_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__)________________________________________>
>__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_LENGTH(character-expression__,_ CODEUNITS16_____)__________>
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
Graphic string:
>__CHARACTER_LENGTH(graphic-expression__,____CODEUNITS16_____)__________>
ǀ_CODEUNITS32_ǀ
>__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)______________________________________________________>
>__DBCLOB(character-expression__________________________________)________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
GRAPHICをDBCLOBに:
>__DBCLOB(graphic-expression____________________________________)________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_,ǀ_CODEUNITS32_ǀ
_,34_
>__DECFLOAT_(_numeric-expression__ǀ_____ǀ_______________________)________>
ǀ_,16_ǀ
文字列をDECFLOATに:
_,34_
>__DECFLOAT_(_string-expression__ǀ_____ǀ________________________)________>
ǀ_,16_ǀ
>_____DECFLOAT_FORMAT___(___string-expression_____________________)______>
ǀ_,_format-string_ǀ
>_DECFLOAT_SORTKEY_ (_decfloat-expression_)______________________________>
>_____DECIMAL___(___numeric-expression_____________________________)_____>
ǀ_DEC_____ǀ ǀ_,precision___________ǀ
ǀ_scale_ǀ
文字列を小数に:
>_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_ǀ
>__EXTRACT(__YEAR____)_FROM__date-expression__________)_________________>
ǀ_MONTH_ǀ ǀ_timestamp-expression_ǀ
ǀ_DAY___ǀ
時間値を抽出:
>__EXTRACT(___HOUR____)_FROM__time-expression__________)________________>
ǀ_MINUTE_ǀ ǀ_timestamp-expression_ǀ
ǀ_SECOND_ǀ
タイムゾーン値を抽出:
>__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)_)__ǀ
>__GRAPHIC(character-expression____________________________________)_______>
ǀ_,_integer______________________ǀ
ǀ_,_CODEUNITS16____ǀ
ǀ_CODEUNITS32_ǀ
グラフィックからグラフィック:
>__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_ǀ
>_LEFT(character-expression,length____________________)___________________>
ǀ_,_CODEUNITS16__ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
グラフィック文字列:
>_LEFT(graphic-expression,length_____________________)____________________>
ǀ_,_CODEUNITS16__ǀ
ǀ_CODEUNITS32_ǀ
バイナリ文字列:
>_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)__________________>
検索引数オプション:
<______________________
>____________________________ǀ___________________________________________>
ǀ_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_ǀ
>_SUBSTRING(character-expression,start,___________,_CODEUNITS16____)_____>
ǀ_,length_ǀ ǀ_CODEUNITS32_ǀ
ǀ__OCTETS_____ǀ
グラフィック:
>_SUBSTRING(graphic-expression,start,____________,_CODEUNITS16____)______>
ǀ_,length_ǀ ǀ_CODEUNITS32_ǀ
バイナリ:
>_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(character-expression_______________________________)__________>
ǀ_,_integer_________________ǀ
ǀ_,_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
ǀ_Octets_ǀ
GraphicからVarcharへ:
>__VARCHAR(graphic-expression___________________________________)__________>
ǀ_,_integer__________________ǀ
ǀ_,_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
DatetimeからVarcharへ:
>__VARCHAR(datetime-expression)____________________________________________>
IntegerからVarcharへ:
>__VARCHAR(integer-expression)_____________________________________________>
DecimalからVarcharへ:
>__VARCHAR(decimal-expression)_____________________________)_______________>
ǀ_,__decimal-character_ǀ
Decimal浮動小数点からVarcharへ:
>__VARCHAR(decimal-floating-point-expression)______________________________>
浮動小数点からVarcharへ:
>__VARCHAR(floating-point-expression)______________________________________>
Row IDからVarcharへ:
>__VARCHAR(row-ID-expression)______________________________________________>
>__VARCHAR_BIT_FORMAT(expression,format-string)____________________________>
>__VARCHAR9(decimal-expression__________________________________)__________>
ǀ_,_decimal-character_____ǀ
>__VARCHAR_FORMAT(character-expression)____________________________________>
タイムスタンプからVARCHARへ:
>__VARCHAR_FORMAT(timestamp-expression,format-string)______________________>
Decimal浮動小数点からVARCHARへ:
>__VARCHAR_FORMAT(decimal-floating-point-expression,format-string)_________>
>__VARGRAPHIC(character-expression____________________________)________>
ǀ_,_integer____________ǀ
ǀ_,_CODEUNITS16__ǀ
ǀ__CODEUNITS32_ǀ
Graphicから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)________________________________________________________>
免責事項: この Db2® 12 for z/OS リファレンスガイドは、Db2 for z/OS の管理およびプログラミングにおける日常の活動を支援するために作成されました。このガイドの内容には、明示または暗黙の保証はありません。ユーザーにとって品質の高く有用なリファレンスを提供したいと考えています。リファレンスガイドに間違いやエラーがあった場合は、blogs@bmc.com までお知らせください。Db2 は IBM Corporation の登録商標です。
Db2ガイド
- Db2 12 for z/OS: はじめに
- Db2 12のスカラー関数
- Db2 12のIBM<sup>®</sup>構文図の読み方
- Db2 12の言語要素
- Db2 12の集約関数
- Db2 12のテーブルおよび行関数
- Db2 12のクエリ
- Db2 12のコマンド
- Db2 12のSQL制御文
- Db2 12の説明テーブル
- Db2 12のDSNZPARM
- Db2 12のバインドパラメータ
- Db2 12の制限
- Db2 12のSQL通信エリア(SQLCA)
- Db2 12のREXX SQLCA
- Db2 12の診断取得
- Db2 12のIFCIDS
- Db2 12のカタログテーブル
- Db2 12の例外
- Db2 12のXMLスキーマリポジトリテーブル
- Db2 12の更新可能カタログ統計
- Db2 12のIBMユーティリティ
- Db2 12のSQL正の戻りコード
- Db2 12のSQLエラー戻りコード
これらの投稿は私自身のものであり、必ずしもBMCの立場、戦略、または意見を表すものではありません。