Archives of the TeradataForum
Message Posted: Thu, 12 Feb 2015 @ 14:40:40 GMT
UDFs are meant to be used inline to act upon result set data row by row by passing in parameters and receiving a calculated result.
Either a macro or stored procedure would run the SQL you have shown, so I am going to assume that the problem you want to solve is multiple invocation of the SQL and use of the result in a where clause or case statement.
If this is the case, why can you not use a table to run once, store and use?
We can help more if we know what the problem is
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|