All Forums Connectivity
mark123 2 posts Joined 05/16
28 Jul 2016
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. 
 
 
 
 
 

mark123 2 posts Joined 05/16
29 Jul 2016

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

You must sign in to leave a comment.