Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 Dec 2007 @ 11:09:47 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: UDF Failure 3706 Syntax error: Invalid statement
From:   Victor Sokovin

  Also, UDF's are pretty serious stuff and I only know one site that would allow them. If you aren't sure about them stay well away as you can do some serious and hard to track damage  

For what it's worth, I'd like to second this.

Historically, C developers have been exterminated from database projects for many years. Reasons: they were too expensive, the stuff they produced was not really transparent to others, it was difficult to test it and it was difficult to maintain it after the original developers were leaving projects. Not a great return on investment, so to speak, and often there was no reason on an average database project to go into this high risk anyway.

Whether these are fair arguments or not I don't know but the fact is that C developers have successfully been exterminated from most database projects (they probably never looked back as they easily found something better to do). With UDF it is not clear who will be writing them. A SQL developer who does not mind spending a few hours in C? Or do you buy the code from somewhere? But who will sell you the code itself? C programs are only affordable when the are sold as compiled executables. No serious vendor will be selling the code itself, it does not make business sense. UDF coming from open source? Not really an option for many companies.

In my opinion, UDF are a good extra feature for very advanced users but otherwise they have no application.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023