I have problem executing query accessing Teradata UDF from Excel. Query executes fine from SQL Assistant but when executed from Excel 2010 it fails and DBQL logs an error message. Query looks like this:
SELECT top 70 from SIM_DATA.udf_ForecastPerion(CAST (sv.EventDate as DATE)) AS SPF_ForecastPeriod
FROM SIM_DATA.ShopVisit sv
and DBQL logs error: 3706 Synatx Error
Wonder if somebody had similar poblem.