Querying teradata with UDF from Excel

Connectivity

Querying teradata with UDF from Excel

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. 

1 REPLY

Re: Querying teradata with UDF from Excel

Aha, Default Database needs to be set in Excel connection or make sure all names are fully qualified in the query itself