Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 08:45:44 GMT

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

All,

this post is in response to the 'Replace function in TD' thread, but I want to get to the more general point of UDFs (user defined functions), so I changed the topic name.

Dennis is right that replace can be implemented as a UDF with the new versions of Teradata. My question is: Should it?

On the one hand I'm very exited about user defined functions, and the fact that I can create a replace function myself if I have to.

On the other hand: We have a post maybe once a month asking for that function. I don't feel like this is the type of functionality I would like to see realized primarily in user defined functions. I think this is something that TD should offer to us (There must be a reason why other DBs have it. Probably something like 'users need this function on a regular basis'.

[disclaimer: I'm one of these people. I used to work on a different DB. I used replace. I loved it. I assumed it would be just there on TD, and was dissapointed when it wasn't]).

I wonder if there is (or even can) be any sort of feedback mechanism, that allows NCR to track which UDFs are commonly implemented. Because something that's implemented on every other TD site should probably really be there out of the Box.

Also, will there be "partners" that maybe offer "suites" of UDFs for sale?

Would it be feasable or even intersting to us (or some of us) to work together on UDFs and share them? Other common functions I could think of would be 'Is number?', 'Is character?', etc. With one word, functions that allow you to check if a cast will be sucessful easily. I'm sure there are a lot more functions out there that could benefit more than only one site. And I don't like the idea of each of us re-inventing the wheel

I would be interested in your thoughts.

Thanks!

Mirjam Berger

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