Was wondering if someone could explain the steps involved in creating a udf, I know a little c but i'm unsure of the steps on how to create one so Teradata recognizes it as a function. So i guess i'm looking for something on how to create one from step 1.
You would want to read the UDF orange book, if you want to go through the step by step stuff. It should be available in The Teradata At your Service website. If you don't have login, your NCR support personnel should be able to help you.
And before doing all that make sure you have a compiler in atleast one of the Teradata PE-Nodes which is required if you install the UDFs as a source. (The general norm).