A packaged query should be used if Sybase-specific SQL is required for a given case. TDV supports a superset of SQL-92, but you can force the use of Sybase-native SQL by creating a packaged query containing the Sybase SQL code. TDV does not evaluate SQL inside of packaged queries.
•
Because Sybase IQ does not count trailing spaces in its LENGTH function, it might be best to set the TDV configuration parameter to Ignore Trailing Spaces.
•
The Sybase data type UNSIGNED BIGINT is not fully supported by TDV queries when its value is larger than +9,223,372,036,854,775,807, because of the limitations of the TDV JDBC type LONG.MAX_VALUE.
•
Queries submitted to Sybase IQ cannot contain column names in the IN clause. The IN clause can contain constants only.