| Previous revision |
| — | sqlways:db2:functions [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 |
|---|
| | \\ |
| | [[https://www.ispirer.com|Ispirer Website]] |
| | [[https://www.ispirer.com/products/db2-migration|Ispirer Capabilities - DB2 Migration]] |
| | [[https://www.ispirer.com/download/download-demo|Free Trial]] |
| | ===== IBM DB2 Functions ===== |
| | |
| | * **[[sqlways:db2/functions/mapping-to-other-databases |SQL Functions Mapping to Other Databases]]** |
| | * **[[sqlways:db2/functions/numeric-functions |Numeric Functions]]** |
| | * [[sqlways:db2/functions/numeric-functions/abs |ABS]] |
| | * [[sqlways:db2/functions/numeric-functions/acos |ACOS]] |
| | * [[sqlways:db2/functions/numeric-functions/asin |ASIN]] |
| | * [[sqlways:db2/functions/numeric-functions/atan |ATAN]] |
| | * [[sqlways:db2/functions/numeric-functions/atanh |ATANH]] |
| | * [[sqlways:db2/functions/numeric-functions/atan2 |ATAN2]] |
| | * [[sqlways:db2/functions/numeric-functions/ceiling |CEILING]] |
| | * [[sqlways:db2/functions/numeric-functions/cos |COS]] |
| | * [[sqlways:db2/functions/numeric-functions/cosh |COSH]] |
| | * [[sqlways:db2/functions/numeric-functions/cot |COT]] |
| | * [[sqlways:db2/functions/numeric-functions/degrees |DEGREES]] |
| | * [[sqlways:db2/functions/numeric-functions/exp |EXP]] |
| | * [[sqlways:db2/functions/numeric-functions/floor |FLOOR]] |
| | * [[sqlways:db2/functions/numeric-functions/ln |LN]] |
| | * [[sqlways:db2/functions/numeric-functions/log |LOG]] |
| | * [[sqlways:db2/functions/numeric-functions/log10 |LOG10]] |
| | * [[sqlways:db2/functions/numeric-functions/mod |MOD]] |
| | * [[sqlways:db2/functions/numeric-functions/multiply-alt |MULTIPLY_ALT]] |
| | * [[sqlways:db2/functions/numeric-functions/power |POWER]] |
| | * [[sqlways:db2/functions/numeric-functions/radians |RADIANS]] |
| | * [[sqlways:db2/functions/numeric-functions/rand |RAND]] |
| | * [[sqlways:db2/functions/numeric-functions/round |ROUND]] |
| | * [[sqlways:db2/functions/numeric-functions/sign |SIGN]] |
| | * [[sqlways:db2/functions/numeric-functions/sin |SIN]] |
| | * [[sqlways:db2/functions/numeric-functions/sinh |SINH]] |
| | * [[sqlways:db2/functions/numeric-functions/sqrt |SQRT]] |
| | * [[sqlways:db2/functions/numeric-functions/tan |TAN]] |
| | * [[sqlways:db2/functions/numeric-functions/tanh |TANH]] |
| | * [[sqlways:db2/functions/numeric-functions/truncate |TRUNCATE]] |
| | * **[[sqlways:db2/functions/string-functions |String Functions]]** |
| | * [[sqlways:db2/functions/string-functions/ascii |ASCII]] |
| | * [[sqlways:db2/functions/string-functions/character-length |CHARACTER_LENGTH]] |
| | * [[sqlways:db2/functions/string-functions/chr |CHR]] |
| | * [[sqlways:db2/functions/string-functions/concat |CONCAT]] |
| | * [[sqlways:db2/functions/string-functions/difference |DIFFERENCE]] |
| | * [[sqlways:db2/functions/string-functions/insert |INSERT]] |
| | * [[sqlways:db2/functions/string-functions/length |LENGTH]] |
| | * [[sqlways:db2/functions/string-functions/lcase |LCASE]] |
| | * [[sqlways:db2/functions/string-functions/left |LEFT]] |
| | * [[sqlways:db2/functions/string-functions/locate |LOCATE]] |
| | * [[sqlways:db2/functions/string-functions/ltrim |LTRIM]] |
| | * [[sqlways:db2/functions/string-functions/octet-length |OCTET_LENGTH]] |
| | * [[sqlways:db2/functions/string-functions/position |POSITION]] |
| | * [[sqlways:db2/functions/string-functions/posstr |POSSTR]] |
| | * [[sqlways:db2/functions/string-functions/repeat |REPEAT]] |
| | * [[sqlways:db2/functions/string-functions/replace |REPLACE]] |
| | * [[sqlways:db2/functions/string-functions/right |RIGHT]] |
| | * [[sqlways:db2/functions/string-functions/rtrim |RTRIM]] |
| | * [[sqlways:db2/functions/string-functions/soundex |SOUNDEX]] |
| | * [[sqlways:db2/functions/string-functions/space |SPACE]] |
| | * [[sqlways:db2/functions/string-functions/strip |STRIP]] |
| | * [[sqlways:db2/functions/string-functions/substr |SUBSTR]] |
| | * [[sqlways:db2/functions/string-functions/substring |SUBSTRING]] |
| | * [[sqlways:db2/functions/string-functions/translate |TRANSLATE]] |
| | * [[sqlways:db2/functions/string-functions/trim |TRIM]] |
| | * [[sqlways:db2/functions/string-functions/ucase |UCASE]] |
| | * **[[sqlways:db2/functions/date-and-time-functions |Date and Time Functions]]** |
| | * [[sqlways:db2/functions/date-and-time-functions/day |DAY]] |
| | * [[sqlways:db2/functions/date-and-time-functions/dayname |DAYNAME]] |
| | * [[sqlways:db2/functions/date-and-time-functions/dayofweek |DAYOFWEEK]] |
| | * [[sqlways:db2/functions/date-and-time-functions/dayofweek-iso |DAYOFWEEK_ISO]] |
| | * [[sqlways:db2/functions/date-and-time-functions/dayofyear |DAYOFYEAR]] |
| | * [[sqlways:db2/functions/date-and-time-functions/days |DAYS]] |
| | * [[sqlways:db2/functions/date-and-time-functions/hour |HOUR]] |
| | * [[sqlways:db2/functions/date-and-time-functions/julian-day |JULIAN_DAY]] |
| | * [[sqlways:db2/functions/date-and-time-functions/microsecond |MICROSECOND]] |
| | * [[sqlways:db2/functions/date-and-time-functions/midnight-seconds |MIDNIGHT_SECONDS]] |
| | * [[sqlways:db2/functions/date-and-time-functions/minute |MINUTE]] |
| | * [[sqlways:db2/functions/date-and-time-functions/month |MONTH]] |
| | * [[sqlways:db2/functions/date-and-time-functions/monthname |MONTHNAME]] |
| | * [[sqlways:db2/functions/date-and-time-functions/quarter |QUARTER]] |
| | * [[sqlways:db2/functions/date-and-time-functions/second |SECOND]] |
| | * [[sqlways:db2/functions/date-and-time-functions/timestamp-format |TIMESTAMP_FORMAT]] |
| | * [[sqlways:db2/functions/date-and-time-functions/timestamp-iso |TIMESTAMP_ISO]] |
| | * [[sqlways:db2/functions/date-and-time-functions/timestampdiff |TIMESTAMPDIFF]] |
| | * [[sqlways:db2/functions/date-and-time-functions/to-char |TO_CHAR]] |
| | * [[sqlways:db2/functions/date-and-time-functions/to-date |TO_DATE]] |
| | * [[sqlways:db2/functions/date-and-time-functions/varchar-format |VARCHAR_FORMAT]] |
| | * [[sqlways:db2/functions/date-and-time-functions/week |WEEK]] |
| | * [[sqlways:db2/functions/date-and-time-functions/week-iso |WEEK_ISO]] |
| | * [[sqlways:db2/functions/date-and-time-functions/year |YEAR]] |
| | * **[[sqlways:db2/functions/analitic-and-aggregate-functions |Analitic and Aggregate Functions]]** |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/avg |AVG]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/correlation |CORRELATION]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/count |COUNT]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/count-big |COUNT_BIG]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/covariance |COVARIANCE]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/grouping |GROUPING]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/max |MAX]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/min |MIN]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-avgx |REGR_AVGX]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-avgy |REGR_AVGY]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-count |REGR_COUNT]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-interceptorregr-icpt |REGR_INTERCEPT or REGR_ICPT]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-r2 |REGR_R2]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-slope |REGR_SLOPE]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-sxx |REGR_SXX]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-sxy |REGR_SXY]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/regr-syy |REGR_SYY]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/stddev |STDDEV]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/sum |SUM]] |
| | * [[sqlways:db2/functions/analitic-and-aggregate-functions/variance |VARIANCE]] |
| | * **[[sqlways:db2/functions/conversion-functions |Conversion Functions]]** |
| | * [[sqlways:db2/functions/conversion-functions/bigint |BIGINT]] |
| | * [[sqlways:db2/functions/conversion-functions/blob |BLOB]] |
| | * [[sqlways:db2/functions/conversion-functions/char |CHAR]] |
| | * [[sqlways:db2/functions/conversion-functions/clob |CLOB]] |
| | * [[sqlways:db2/functions/conversion-functions/date |DATE]] |
| | * [[sqlways:db2/functions/conversion-functions/dbclob |DBCLOB]] |
| | * [[sqlways:db2/functions/conversion-functions/decimal |DECIMAL]] |
| | * [[sqlways:db2/functions/conversion-functions/decrypt-bin |DECRYPT_BIN]] |
| | * [[sqlways:db2/functions/conversion-functions/decrypt-char |DECRYPT_CHAR]] |
| | * [[sqlways:db2/functions/conversion-functions/digits |DIGITS]] |
| | * [[sqlways:db2/functions/conversion-functions/double |DOUBLE]] |
| | * [[sqlways:db2/functions/conversion-functions/encrypt |ENCRYPT]] |
| | * [[sqlways:db2/functions/conversion-functions/float |FLOAT]] |
| | * [[sqlways:db2/functions/conversion-functions/graphic |GRAPHIC]] |
| | * [[sqlways:db2/functions/conversion-functions/hex |HEX]] |
| | * [[sqlways:db2/functions/conversion-functions/rec2xml |REC2XML]] |
| | * [[sqlways:db2/functions/conversion-functions/integer |INTEGER]] |
| | * [[sqlways:db2/functions/conversion-functions/long-varchar |LONG_VARCHAR]] |
| | * [[sqlways:db2/functions/conversion-functions/long-vargraphic |LONG_VARGRAPHIC]] |
| | * [[sqlways:db2/functions/conversion-functions/real |REAL]] |
| | * [[sqlways:db2/functions/conversion-functions/smallint |SMALLINT]] |
| | * [[sqlways:db2/functions/conversion-functions/time |TIME]] |
| | * [[sqlways:db2/functions/conversion-functions/timestamp |TIMESTAMP]] |
| | * [[sqlways:db2/functions/conversion-functions/varchar |VARCHAR]] |
| | * [[sqlways:db2/functions/conversion-functions/vargraphic |VARGRAPHIC]] |
| | * **[[sqlways:db2/functions/xml-functions |XML Functions]]** |
| | * [[sqlways:db2/functions/xml-functions/xmlagg |XMLAGG]] |
| | * [[sqlways:db2/functions/xml-functions/xmlattributes |XMLATTRIBUTES]] |
| | * [[sqlways:db2/functions/xml-functions/xmlcomment |XMLCOMMENT]] |
| | * [[sqlways:db2/functions/xml-functions/xmlconcat |XMLCONCAT]] |
| | * [[sqlways:db2/functions/xml-functions/xmldocument |XMLDOCUMENT]] |
| | * [[sqlways:db2/functions/xml-functions/xmlelement |XMLELEMENT]] |
| | * [[sqlways:db2/functions/xml-functions/xmlforest |XMLFOREST]] |
| | * [[sqlways:db2/functions/xml-functions/xmlnamespaces |XMLNAMESPACES]] |
| | * [[sqlways:db2/functions/xml-functions/xmlparse |XMLPARSE]] |
| | * [[sqlways:db2/functions/xml-functions/xmlpi |XMLPI]] |
| | * [[sqlways:db2/functions/xml-functions/xmlquery |XMLQUERY]] |
| | * [[sqlways:db2/functions/xml-functions/xmlserialize |XMLSERIALIZE]] |
| | * [[sqlways:db2/functions/xml-functions/xmltable |XMLTABLE]] |
| | * [[sqlways:db2/functions/xml-functions/xmltext |XMLTEXT]] |
| | * [[sqlways:db2/functions/xml-functions/xmlvalidate |XMLVALIDATE]] |
| | * [[sqlways:db2/functions/xml-functions/xmlxsrobjectid |XMLXSROBJECTID]] |
| | * **[[sqlways:db2/functions/environment-and-system-functions |Environment and System Functions]]** |
| | * [[sqlways:db2/functions/environment-and-system-functions/coalesce |COALESCE]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/deref |DEREF]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/event-mon-state |EVENT_MON_STATE]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/generate-unique |GENERATE_UNIQUE]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/gethint |GETHINT]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/identity-val-local |IDENTITY_VAL_LOCAL]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/nullif |NULLIF]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/raise-error |RAISE_ERROR]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/table-name |TABLE_NAME]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/table-schema |TABLE_SCHEMA]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/type-id |TYPE_ID]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/type-name |TYPE_NAME]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/type-schema |TYPE_SCHEMA]] |
| | * [[sqlways:db2/functions/environment-and-system-functions/value |VALUE]] |
| | * **[[sqlways:db2/functions/other-functions |Other Functions]]** |
| | * [[sqlways:db2/functions/other-functions/dbpartitionnum |DBPARTITIONNUM]] |
| | * [[sqlways:db2/functions/other-functions/hashedvalue |HASHEDVALUE]] |
| | * [[sqlways:db2/functions/other-functions/seclabel |SECLABEL]] |
| | * [[sqlways:db2/functions/other-functions/seclabel-by-name |SECLABEL_BY_NAME]] |
| | * [[sqlways:db2/functions/other-functions/seclabel-to-char |SECLABEL_TO_CHAR]] |
| |
