| RamanGrover29@gmail.com | 58cf330 | 2012-11-09 00:27:45 +0000 | [diff] [blame] | 1 | /* |
| 2 | * Description : Create UDF to verify if input is odd | ||||
| 3 | * Expected Res : Success | ||||
| 4 | * Date : Sep 5th 2012 | ||||
| 5 | */ | ||||
| 6 | |||||
| 7 | drop dataverse test if exists; | ||||
| 8 | create dataverse test; | ||||
| 9 | |||||
| RamanGrover29@gmail.com | 2471039 | 2012-11-11 18:57:42 +0000 | [diff] [blame] | 10 | write output to nc1:"rttest/user-defined-functions_udf21.adm"; |
| RamanGrover29@gmail.com | 58cf330 | 2012-11-09 00:27:45 +0000 | [diff] [blame] | 11 | |
| 12 | create function test.isOdd($b){ | ||||
| 13 | $b%2 != 0 | ||||
| 14 | } | ||||
| 15 | |||||
| 16 | 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] | ||||
| 17 | where test.isOdd($a) | ||||
| 18 | return $a | ||||