Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:db2:functions [May 07, 2018, 03:15:26 PM] (current)
Line 1: Line 1:
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/db2-migration|Ispirer SQLWays Product Page - Migration to IBM DB2]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
 +
 +===== 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]]
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/db2-migration|Ispirer SQLWays Product Page - Migration to IBM DB2]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
 +
  
sqlways/db2/functions.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement