Panel Progress
TIBCO Data Virtualization®
Web UI - User Guide
Preface
Product-Specific Documentation
How to Access TIBCO Documentation
How to Contact TIBCO Support
How to Join TIBCO Community
Introduction
System Requirements
How to Access TDV Web UI
Accessing from TDV Studio
Logging in to TDV Web UI
User Management
The Login Screen
Overview of the Data Catalog
Overview of the Flow Editor
Navigation
Signing out of TDV Web UI
Accessing Online Help
Data Catalog
Resource Tree
Search/Filter Resource
Resource Details
Creating a New Flow
Flow Editor
Creating a Flow
The Operations Palette
Adding a Dataset
Adding Columns
Adding Filter
JOIN Operation
UNION Operation
EXCEPT Operation
INTERSECT Operation
Expression Editor
Publishing a Flow
Editing a Published Flow
TDV Support for SQL Functions
About SQL Functions in TDV
Analytical Functions
Window Clause
CONDITIONAL_CHANGE_EVENT
CONDITIONAL_TRUE_EVENT
CUME_DIST
DENSE_RANK
EXPONENTIAL_MOVING_AVERAGE
EXPONENTIAL_WEIGHTED_AVERAGE
FIRST_VALUE
FIRST_VALUE_IGNORE_NULLS
LAG
LAG_IGNORE_NULLS
LAST_VALUE
LAST_VALUE_IGNORE_NULLS
LEAD
LEAD_IGNORE_NULLS
NTH_VALUE
NTH_VALUE_FROM_LAST
NTH_VALUE_FROM_LAST_IGNORE_NULLS
NTH_VALUE_IGNORE_NULLS
NTILE
PERCENT_RANK
RANK
RATIO_TO_REPORT
ROW_NUMBER
TIMESERIES
Aggregate Functions
ANY_VALUE
APPROX_COUNT_DISTINCT
APPROX_QUANTILES
ARRAY_AGG
AVG
BIT_AND
BIT_OR
BIT_XOR
CORR
CORR_SPEARMAN
COUNT
COVAR_POP
COVAR_SAMP
DISTINCT in Aggregate Functions
FIRST
GROUP_CONCAT
GROUP_CONCAT_UNQUOTED
LAST
JSON_OBJECTAGG
JSON_ARRAYAGG
LISTAGG
MAX
MEDIAN
MIN
NEST
NTH
PERCENTILE
PERCENTILE_APPROX
PERCENTILE_CONT
PERCENTILE_DISC
QUANTILES
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_ SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
SUM_FLOAT
VAR_POP
VAR_SAMP
VARIANCE
XMLAGG
Array SQL Script Functions
ARRAY_APPEND
ARRAY_AVG
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_COUNT
ARRAY_DISTINCT
ARRAY_IFNULL
ARRAY_LENGTH
ARRAY_MAX
ARRAY_MIN
ARRAY_POSITION
ARRAY_PREPEND
ARRAY_PUT
ARRAY_REMOVE
ARRAY_REPLACE
ARRAY_REVERSE
ARRAY_SORT
ARRAY_SUM
TOARRAY
TOATOM
TOBOOLEAN
TONUMBERCB
TOOBJECT
TOSTRING
Binary Functions
AND Functions
NOT Functions
OR Functions
SHL Functions
SHR Functions
XOR Functions
BYTE_SUBSTR
Character Functions
ASCII
BASE64
BITCOUNT
BIT_LENGTH
BITSTRING_TO_BINARY
BTRIM
CHAR_LENGTH
CHARACTER_LENGTH
CHARINDEX
CHR
CONCAT
CONTAINS
DLE_DST
ENDSWITH
FIND
FIND_IN_SET
GET_JSON_OBJECT
GREATEST
HEX_TO_BINARY
INDEXOF
INET_ATON
INET_NTOA
INITCAP
INSERT
INSTR
ISOF
ISUTF8
LCASE
LEAST
LEFT
LENGTH
LE_DST
LOCATE
LOWER
LPAD
LSHIFT
LTRIM
MD5
OCTET_LENGTH
OVERLAYB
PARSE_URL
PARTIAL_STRING_MASK
POSITION
QUOTE_IDENT
QUOTE_LITERAL
REGEXP_CONTAINS
REGEXP_COUNT
REGEXP_EXTRACT
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REGEXP_LIKE
REGEXP_POSITION
REPEAT
REVERSE
RIGHT
REPLACE
REGEXP
RLIKE
RPAD
RSHIFT
RTRIM
SPACE
SPLIT
SPLIT_PART
STARTSWITH
STATEMENT_TIMESTAMP
STRPOS
SUBSTR
SUBSTRING
SUBSTRINGOF
TRANSLATE
TRIM
TRIMBOTH
TRIMLEADING
TRIMTRAILING
TYPE
UCASE
UNICHR
UNICODE
UPPER
V6_ATON
V6_NTOA
V6_SUBNETA
V6_SUBNETN
V6_TYPE
Conditional Functions
COALESCE
COMMON
DECODE
ES_MATCH
FILTER
IFINF
IFMISSING
IFMISSINGORNULL
IFNAN
IFNANORINF
IFNULL
IFNULLCB
ISARRAY
ISATOM
ISBOOLEAN
ISNUMBER
ISOBJECT
ISNULL
ISNUMERIC
ISSTRING
MATCH_PHRASE
MATCH_PHRASE_PREFIX
MISSINGIF
NANIF
NEGINFIF
NULLIF
NVL
NVL2
POSINFIF
TERM
TEST
Convert Functions
CAST
FORMAT_DATE
PARSE_DATE
PARSE_TIME
PARSE_TIMESTAMP
TIMESTAMP
TO_BITSTRING
TO_CHAR
TO_DATE
TO_HEX
TO_NUMBER
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TRUNC (for date/time)
TRUNC (for numbers)
TRUNCATE
Cryptographic Functions
HASHMD2
HASHMD4
HASHMD5
HASHSHA
HASHSHA1
Date Functions
ADD_MONTHS
AGE
AT TIME ZONE
CALENDAR_MONTH
CALENDAR_QUARTER
CALENDAR_YEAR
CLOCK_MILLIS
CLOCK_STR
CLOCK_TIMESTAMP
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATE
DATE_ADD
DATE_ADD_MILLIS
DATE_ADD_STR
DATE_DIFF_MILLIS
DATE_DIFF_STR
DATE_PART
DATENAME
DATEPART
DATE_PART_MILLIS
DATE_PART_STR
DATE_SUB
DATE_TRUNC
DATETRUNC
DATE_TRUNC_MILLIS
DATE_TRUNC_STR
DAY_IN_MONTH
DAY_IN_WEEK
DAY_IN_YEAR
DAYNAME
DAYOFMONTH
DAYOFWEEK_ISO
DAYOFWEEK
DAYOFYEAR
DAY_ONLY
DATEDIFF
DAY, MONTH, and YEAR
DAYS
DAYS_BETWEEN
DBTIMEZONE
EXTRACT
EXTRACTDAY
EXTRACTDOW
EXTRACTDOY
EXTRACTEPOCH
EXTRACTHOUR
EXTRACTMICROSECOND
EXTRACTMILLISECOND
EXTRACTMINUTE
EXTRACTMONTH
EXTRACTQUARTER
EXTRACTSECOND
EXTRACTWEEK
EXTRACTYEAR
FISCAL_MONTH
FISCAL_QUARTER
FISCAL_YEAR
FRACTIONALSECONDS
FROM_UNIXTIME
GETUTCDATE
HOUR
HOUR_IN_DAY
ISFINITE
ISUTF8
JULIAN_DAY
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MICROSECOND
MIDNIGHT_SECONDS
MILLIS
MILLIS_TO_STR
MILLIS_TO_UTC
MAXDATETIME
MINDATETIME
MINUTE
MONTHNAME
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
NOW
NOW_MILLIS
NOW_STR
NUMTODSINTERVAL
NUMTOYMINTERVAL
QUARTER
ROUND
SECOND
STR_TO_MILLIS
STR_TO_UTC
STR_TO_ZONE_NAME
SYSDATE
TIME
TIMESTAMP_ROUND
TIME_SLICE
TIMEOFDAY
TIMESTAMPADD
TIMESTAMPDIFF
TIMESTAMP_TRUNC
TRANSACTION_TIMESTAMP
TOTALOFFSETMINUTES
TOTALSECONDS
TZ_OFFSET
TZCONVERTOR
UNIX_TIMESTAMP
UTC_TO_TIMESTAMP
WEEK
WEEK_ISO
WEEK_IN_MONTH
WEEK_IN_YEAR
YEAR_ISO
JSON Functions
DECODE_JSON
ENCODE_JSON
ENCODED_SIZE
JSON_TABLE
JSON_EXTRACT
JSON_EXTRACT_SCALAR
JSON_COUNT
JSON_SUM
JSON_MIN
JSON_MAX
JSON_AVG
JSON_PATH
JSON_OBJECT
JSON_ARRAY
Numeric Functions
ABS
ACOS
ASIN
ATAN
ATAN2
CBRT
CEILING
COS
COSH
COT
DECFLOAT
DEGREES
E
EXP
FLOOR
GEO.DISTANCE
GEO.INTERSECTS
GEO.LENGTH
LN
LOG
LOG10
MOD
NEGATIVE
NORMALIZE_DECFLOAT
PI
POW
POWER
Quantize
RADIANS
RAND
RANDOM
ROUND (for date/time)
ROUND (for numbers)
ROWNUM
SIGN
SIN
SINH
SQRT
TAN
TANH
TOTALORDER
Operator Functions
Add-Operator
Concatenate-Operator
Divide-Operator
Exponentiate-Operator
Factorial-Operator
FACTORIAL
Module-Operator
Multiply-Operator
Negate-Operator
Subtract-Operator
Phonetic Functions
DBL_MP
NYSIIS
PRI_MP
SCORE_MP
SEC_MP
SOUNDEX
DIFFERENCE
Utility Function
XML Functions
Identifier Escaping
Text Escaping
XMLATTRIBUTES
XMLCOMMENT
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XML_EXTRACT
XMLFOREST
XMLNAMESPACES
XMLPI
XMLQUERY
XMLTEXT
XPATH
XSLT
Index
TIBCO Data Virtualization®
XSLT