 |
 |
Archives of the TeradataForum
Message Posted: Fri, 14 Dec 2007 @ 11:09:47 GMT
| 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.
Regards,
Victor
| |
