We have a SQL query that we are running using the Teradata Connector stage. The SQL calls a UDF (user defined function) to format one of the columns. The query runs fine from other tools, and the job executes fine. However, there is a warning sign next to the SQL property in the TD Conn stage:
Invalid property value: Unexpected procedure reference found
If I comment out the UDF, the message goes away. I can call the UDF with or without the appropriate database reference (lpad() or syslib.lpad()) and it does not change it. I can run the job just fine, so what is going on?
Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.
its a bug :D . and this is not the only one. if you use formatting, etc it will also come up with the same warning. in some cases if you run the job even though this warning is present it works fine .. cheeky
So far, we have gotten this message for UDF's and OLAP functions (ex. RANK... ORDER BY). And yes, we get the warning but it executes just fine. Thanks!
Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.
Have'nt asked for any patches for this yet. we just do it through views now. i.e. perform any such functions in views and then just do a select insert from there in the after SQL.
Have'nt asked for any patches for this yet. we just do it through views now. i.e. perform any such functions in views and then just do a select insert from there in the after SQL.