Auf einen Blick: Skalare Funktionen in Db2 12 erweitern SQL-Abfragen mit wesentlichen Werkzeugen für Datenmanipulation und -abruf und decken verschiedene skalare Funktionen mit Syntaxbeispielen ab.
- Funktionen umfassen unter anderem ABS, ACOS und ADD_MONTHS.
- Jede Funktion wird von detaillierten Beispielen zur Benutzerorientierung begleitet.
>__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______________________________________________>
String zu 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__)________________________________________>
>__CHAR(datetime-expression________________)_____________________________>
ǀ_,____ISO____ǀ
ǀ_USA___ǀ
ǀ_EUR___ǀ
ǀ_JIS___ǀ
ǀ_LOCAL_ǀ
Charakter zu Charakter:
>__CHAR(character-expression_______________________________)_____________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
ǀ_OCTETS______ǀ
Grafik für die Figur:
__CHAR(graphic-expression____________________________________)__________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
Ganzzahl zu Charakter:
>__CHAR(integer-expression)______________________________________________>
Dezimalform zum Zeichen:
>__CHAR(decimal-expression)___________________________)__________________>
ǀ_,__decimal-character_ǀ
Dezimale Gleitkomma-Punkte zum Zeichen:
>__CHAR(decimal-floating-point-expression)______________________________>
Gleitkomma-Charakter:
>__CHAR(floating-point-expression)______________________________________>
Zeilen-ID zum Charakter:
>__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_ǀ
Such-Argument-Optionen:
<______________________
>________________________________ǀ______________________________________>
ǀ_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_ǀ
GRAFIK zu DBCLOB:
>__DBCLOB(graphic-expression____________________________________)________>
ǀ_,_integer__________________ǀ
ǀ_,ǀ_CODEUNITS16_ǀ
ǀ_,ǀ_CODEUNITS32_ǀ
_,34_
>__DECFLOAT_(_numeric-expression__ǀ_____ǀ_______________________)________>
ǀ_,16_ǀ
String zu DECFLOAT:
_,34_
>__DECFLOAT_(_string-expression__ǀ_____ǀ________________________)________>
ǀ_,16_ǀ
>_____DECFLOAT_FORMAT___(___string-expression_____________________)______>
ǀ_,_format-string_ǀ
>_DECFLOAT_SORTKEY_ (_decfloat-expression_)______________________________>
>_____DECIMAL___(___numeric-expression_____________________________)_____>
ǀ_DEC_____ǀ ǀ_,precision___________ǀ
ǀ_scale_ǀ
String bis Dezimal:
>_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_ǀ
ERFAHRUNG
>__EXP (numerischer Ausdruck)_______________________________________________>
EXTRAKT
Datumswerte extrahieren:
>__EXTRACT(__YEAR____)_FROM__date-expression__________)_________________>
ǀ_MONTH_ǀ ǀ_timestamp-expression_ǀ
ǀ_DAY___ǀ
Zeitwerte extrahieren:
>__EXTRACT(___HOUR____)_FROM__time-expression__________)________________>
ǀ_MINUTE_ǀ ǀ_timestamp-expression_ǀ
ǀ_SECOND_ǀ
Zeitzonenwerte extrahieren:
>__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
<__________
>__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_ǀ
Von Grafik zu Grafik:
>__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______ǀ
Grafische Zeichenkette:
>_LEFT(graphic-expression,length_____________________)____________________>
ǀ_,_CODEUNITS16__ǀ
ǀ_CODEUNITS32_ǀ
Binäre Zeichenkette:
>_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)__________________>
Such-Argument-Optionen:
<______________________
>____________________________ǀ___________________________________________>
ǀ_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_____ǀ
Grafik:
>_SUBSTRING(graphic-expression,start,____________,_CODEUNITS16____)______>
ǀ_,length_ǀ ǀ_CODEUNITS32_ǀ
Binär:
>_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_ǀ
Grafik an Varchar:
>__VARCHAR(graphic-expression___________________________________)__________>
ǀ_,_integer__________________ǀ
ǀ_,_CODEUNITS16_ǀ
ǀ_CODEUNITS32_ǀ
Datum für Varchar:
>__VARCHAR(datetime-expression)____________________________________________>
Ganzzahl zu Varchar:
>__VARCHAR(integer-expression)_____________________________________________>
Dezimal bis Varchar:
>__VARCHAR(decimal-expression)_____________________________)_______________>
ǀ_,__decimal-character_ǀ
Dezimale Gleitkomma-Punkte zu Varchar:
>__VARCHAR(decimal-floating-point-expression)______________________________>
Gleitkomma-Punkt zu Varchar:
>__VARCHAR(floating-point-expression)______________________________________>
Zeilen-ID an Varchar:
>__VARCHAR(row-ID-expression)______________________________________________>
>__VARCHAR_BIT_FORMAT(expression,format-string)____________________________>
>__VARCHAR9(decimal-expression__________________________________)__________>
ǀ_,_decimal-character_____ǀ
>__VARCHAR_FORMAT(character-expression)____________________________________>
Zeitstempel für VARCHAR:
>__VARCHAR_FORMAT(timestamp-expression,format-string)______________________>
Dezimale Gleitkomma-Zahl zu VARCHAR:
>__VARCHAR_FORMAT(decimal-floating-point-expression,format-string)_________>
>__VARGRAPHIC(character-expression____________________________)________>
ǀ_,_integer____________ǀ
ǀ_,_CODEUNITS16__ǀ
ǀ__CODEUNITS32_ǀ
Von Graphic zu 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__ǀ___ǀ
Datentyp:
_(_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)________________________________________________________>
Haftungsausschluss: Dieser Db2® 12 für z/OS Referenzleitfaden wurde entwickelt, um Nutzern bei ihren täglichen Aktivitäten bei der Verwaltung und Programmierung in Db2 für z/OS zu helfen. Mit den Inhalten dieses Leitfadens gibt es keine ausdrücklich oder stillschweigenden Garantien. Wir möchten den Nutzern eine qualitativ hochwertige und nützliche Referenz bereitstellen. Bitte informieren Sie uns über Fehler oder Fehler in diesem Referenzhandbuch unter blogs@bmc.com. Db2 ist eine eingetragene Marke der IBM Corporation.
Db2-Leitfaden
- Db2 12 für z/OS: Eine Einführung
- Skalare Funktionen in Db2 12
- Wie man IBM<sup>®</sup> Syntaxdiagramme für Db2 12 liest
- Sprachelemente in Db2 12
- Aggregierte Funktionen in Db2 12
- Tabellen- und Zeilenfunktionen in Db2 12
- Anfragen in Db2 12
- Befehle in Db2 12
- SQL-Kontrollanweisungen in Db2 12
- Erkläre Tabellen in Db2 12
- DSNZPARMs in Db2 12
- Bindeparameter in Db2 12
- Db2-Grenzen in Db2 12
- SQL Kommunikationsbereich (SQLCA) in Db2 12
- REXX SQLCA in Db2 12
- Diagnoses in Db2 12 erhalten
- IFCIDS in Db2 12
- Katalogtabellen in Db2 12
- Ausnahmen in Db2 12
- XML-Schema-Repository-Tabellen in Db2 12
- Aktualisierungsfähige Katalogstatistiken in Db2 12
- IBM Utilities in Db2 12
- SQL Positive Return-Codes in Db2 12
- SQL-Fehlerrückgabecodes in Db2 12
Diese Beiträge sind meine eigenen und spiegeln nicht unbedingt die Position, Strategien oder Meinung von BMC wider.