Did write a function ISDATE which will validate yyyy-mm-dd format and send return code of either Correct,Incorrect or Null. When running this function the first time it work correctly, but when rerun or run more than once, then the results became scew, one time the date will be validated correctly sometimes not. There is a posibility that it is a memory leak. Did anyone exprience the same kind of problem and how should i go about solving this
You need to look at the Teradata documentation as to how to build a proper UDF prototype. What you have there is not correct. We can’t really provide any help until you let is know what your CREATE function statement looks like. If you don’t specify it correctly all sorts of strange things can happen, including the system crashing on you.
But in looking at the code I see you have the following