DB2 - SQL - Scalar functions - Ordem alfabética - www.cadcobol.com.br
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
DB2 - SQL - Scalar functions - Ordem alfabética
ABS or ABSVAL
ACOS
ADD_DAYS
ADD_HOURS
ADD_MINUTES
ADD_MONTHS
ADD_SECONDS
ADD_YEARS
AGE
ARRAY_AGG
ARRAY_DELETE
ARRAY_FIRST
ARRAY_LAST
ARRAY_NEXT
ARRAY_PRIOR
ASCII
ASIN
ATAN
ATAN2
ATANH
AVG
BASE_TABLE
BIGINT
BINARY
BITAND
BITANDNOT
BITNOT
BITOR
BITXOR
BLOB
BOOLEAN
BSON_TO_JSON
BTRIM
CARDINALITY
CEILING or CEIL
CHAR
CHARACTER_LENGTH
CHR
CLOB
COALESCE
COLLATION_KEY
COLLATION_KEY_BIT
COMPARE_DECFLOAT
CONCAT
CORRELATION
COS
COSH
COT
COUNT
COUNT_BIG
COVARIANCE
COVARIANCE_SAMP
CUME_DIST
CURSOR_ROWCOUNT
DATAPARTITIONNUM
DATE
DATE_PART
DATE_TRUNC
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFWEEK_ISO
DAYOFYEAR
DAYS
DAYS_BETWEEN
DAYS_TO_END_OF_MONTH
DBCLOB
DBPARTITIONNUM
DECFLOAT
DECFLOAT_FORMAT
DECIMAL or DEC
DECODE
DECRYPT_BIN
DECRYPT_CHAR
DEGREES
DEREF
DIFFERENCE
DIGITS
DOUBLE
DOUBLE_PRECISION
EMPTY_BLOB
EMPTY_CLOB
EMPTY_DBCLOB
EMPTY_NCLOB
ENCRYPT
EVENT_MON_STATE
EXP
EXTRACT
FIRST_DAY
FLOAT
FLOOR
FROM_UTC_TIMESTAMP
GENERATE_UNIQUE
GETHINT
GRAPHIC
GREATEST
GROUPING
HASH
HASH4
HASH8
HASHEDVALUE
HEX
HOUR
HOURS_BETWEEN
IDENTITY_VAL_LOCAL
INITCAP
INSERT
INSTR
INSTRB
INT
INTEGER
INTNAND
INTNNOT
INTNOR
INTNXOR
JSON_ARRAY
JSON_OBJECT
JSON_QUERY
JSON_TABLE
JSON_TO_BSON
JSON_VALUE
JULIAN_DAY
LAST_DAY
LCASE
LCASE (locale)
LCASE (SYSFUN)
LEAST
LEFT
LENGTH
LISTAGG
LN
LOCATE
LOCATE_IN_STRING
LOG10
LOWER
LOWER (locale)
LPAD
LTRIM
LTRIM (SYSFUN)
MAX
MAX_CARDINALITY
MEDIAN
MICROSECOND
MIDNIGHT_SECONDS
MIN
MINUTE
MINUTES_BETWEEN
MOD (SYSFUN)
MOD
MONTH
MONTHNAME
MONTHS_BETWEEN
MULTIPLY_ALT
NCHAR
NCLOB
NEXT_DAY
NEXT_MONTH
NEXT_QUARTER
NEXT_WEEK
NEXT_YEAR
NORMALIZE_DECFLOAT
NOW
NULLIF
NVARCHAR
NVL
OCTET_LENGTH
OVERLAY
PARAMETER
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
POSITION
POSSTR
POW
POWER
QUANTIZE
QUARTER
RADIANS
RAISE_ERROR
RAND (SYSFUN)
RAND (SYSIBM)
RANDOM
RAWTOHEX
REAL
REC2XML
REGEXP_COUNT
REGEXP_EXTRACT
REGEXP_INSTR
REGEXP_LIKE
REGEXP_MATCH_COUNT
REGEXP_REPLACE
REGEXP_SUBSTR
Regression functions
REPEAT
REPEAT (SYSFUN)
REPLACE
REPLACE (SYSFUN)
RID and RID_BIT
RIGHT
ROUND
ROUND_TIMESTAMP
RPAD
RTRIM
RTRIM (SYSFUN)
SECLABEL
SECLABEL_BY_NAME
SECLABEL_TO_CHAR
SECOND
SECONDS_BETWEEN
SIGN
SIN
SINH
SMALLINT
SOUNDEX
SPACE
SQRT
STDDEV
STDDEV_SAMP
STRIP
STRLEFT
STRPOS
STRRIGHT
SUBSTR
SUBSTRB
SUBSTRING
SUM
TABLE_NAME
TABLE_SCHEMA
TAN
TANH
THIS_MONTH
THIS_QUARTER
THIS_WEEK
THIS_YEAR
TIME
TIMESTAMP
TIMESTAMP_FORMAT
TIMESTAMP_ISO
TIMESTAMPDIFF
TO_CHAR
TO_CLOB
TO_DATE
TO_HEX
TO_NCHAR
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_UTC_TIMESTAMP
TOTALORDER
TRANSLATE
TRIM
TRIM_ARRAY
TRUNC_TIMESTAMP
TRUNCATE or TRUNC
TYPE_ID
TYPE_NAME
TYPE_SCHEMA
UCASE
UCASE (locale)
UNNEST
UPPER
UPPER (locale)
VALUE
VARBINARY
VARCHAR
VARCHAR_FORMAT
VARGRAPHIC
VARIANCE
VARIANCE_SAMP
VERIFY_GROUP_FOR_USER
VERIFY_ROLE_FOR_USER
VERIFY_TRUSTED
WEEK
WEEK_ISO
WEEKS_BETWEEN
WIDTH_BUCKET
XMLAGG
XMLATTRIBUTES
XMLCOMMENT
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLFOREST
XMLGROUP
XMLPARSE
XMLPI
XMLQUERY
XMLROW
XMLSERIALIZE
XMLNAMESPACES
XMLTABLE
XMLTEXT
XMLVALIDATE
XMLXSROBJECTID
XSLTRANSFORM
YEAR
YEARS_BETWEEN
YMD_BETWEEN
