sql support

Showing 10

TZCONVERTOR SQL import failure

In cases where the data source provides a valid date but an "unacceptable" timestamp, SQL imports fail with an error message stating "Illegal instant due to time zone offset transition." While this issue is not uncommon across various systems, we'...

over 1 year ago in TIBCO Data Virtualization / sql support 0 Future Consideration

4 VOTE

I would like the ability to search columns to join tables on the model tab.

When joining tables in the Model tab, the columns to be joined must be found in the UI and joined. This reduces productivity when there are many columns. This reduces productivity because of the time and effort required to search for the target co...

over 2 years ago in TIBCO Data Virtualization / sql support 1 Future Consideration

7 VOTE

Add support for ARRAY data type, as in postgres or greenplum

Our users are accessing postgres and greenplum databases which have tables making use of the ARRAY data type (modifier), typically on character varying and double precision basic data types. Out users ask if there is any method or function to inde...

over 6 years ago in TIBCO Data Virtualization / sql support 0 Future Consideration

8 VOTE

Function compatibility help

Information of supported functions is essential in order to write good performing queries. Function support for Data Sources could he part of Studio help. Developers could quickly check the compatibility of functions used in their queries.

over 7 years ago in TIBCO Data Virtualization / sql support 5 Future Consideration

5 VOTE

Support LAG and LEAD functions for DB2

LAG and LEAD functions are supported by DB2, so a push down should not be very hard.

about 6 years ago in TIBCO Data Virtualization / sql support 2 Future Consideration

5 VOTE

Support Oracle 18c

No description provided

over 6 years ago in TIBCO Data Virtualization / sql support 0 Future Consideration

1 VOTE

Add an hashfunction base on the SHA-256 algoritme to TDV

In case 02225472 I asked you "Dear Tibco-support-people, In TDV there is a sql statement HASHMD2, which hashs strings with the use of the MD2 hash-algoritme. Example: select hashmd2('hello tibco') results in b86f42e31e1aba5055b72b78381aa01c Unfort...

over 1 year ago in TIBCO Data Virtualization / sql support 0 Future Consideration

1 VOTE

SQL JSON parsing in TDV should be improved

Using JSON_TABLE is cumbersome, and there are no examples on how to do JSON parsing in a simple way using a transformation (can it even be done?). As an example, Postgres has a simpler syntax allowing queries like this : SELECT id, data::json->...

over 1 year ago in TIBCO Data Virtualization / sql support 0 Future Consideration

4 VOTE

Allow virtual columns to support IN clauses/multiple value filtering

We have customers using virtual columns in an SQL view, e.g: Select *, {DECLARE p_postdate date } p_postdate from table where post_date=p_postdate This functionality needs to be expanded to support multiple values pf p_postdate (i.e, an IN claus...

over 6 years ago in TIBCO Data Virtualization / sql support 0 Future Consideration

3 VOTE

Inclusion of more regular expressions in TDV just like it is present in Oracle

There are several queries where we need regular expressions like REGEXP_LIKE ,some of the regular expressions are not supported so it would be nice if those can be inlcudes

over 6 years ago in TIBCO Data Virtualization / sql support 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY