/* | |
* 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/cross-dataverse_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 |