Cross Connection Query Builder using Toad Intelligence Central data and DB2 iSeries data.
Added a Subquery with a Function named “testdate”. When the Function added is set to “days(date( KWLBASE.MEDATE ))”, the “testdate” column does NOT appear in the Model or Diagram, but the query runs fine and shows all the columns.
If the same Function is changed to “to_days ( KWLBASE.MEDATE )”, the “testdate” column appears in the Model or Diagram, but the query now gets the error: “Got error 4208 '{0} ODBC data source returned an error: SQL0204 - TO_DAYS in *LIBL type *N not found.' from HUB”
In addition, the 2nd level or nested Subquery columns does not show in the Model or Diagram.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad Data Point.
