| /* | |
| * Description : Create UDF to verify if input is odd | |
| * Expected Res : Success | |
| * Date : Sep 5th 2012 | |
| */ | |
| drop dataverse test if exists; | |
| create dataverse test; | |
| write output to nc1:"rttest/user-defined-functions_udf21.adm"; | |
| create function test.isOdd($b){ | |
| $b%2 != 0 | |
| } | |
| for $a in [10,20,2,30,4,3,6,44,5,7,9,1,13,17,992,19,40,50,60,25,45,65,75] | |
| where test.isOdd($a) | |
| return $a |