/* | |
* Description : Create user defined functions using fully qualified names | |
* : verify their details in Function dataset in Metadata dataverse. | |
* Expected Res : | |
* Date : 30th Aug 2012 | |
*/ | |
drop dataverse testdv1 if exists; | |
create dataverse testdv1; | |
write output to nc1:"rttest/cross-dataverse_cross-dv15.adm"; | |
// UDF with no inputs | |
create function testdv1.fun01(){ | |
100 | |
} | |
// UDF with one input | |
create function testdv1.fun02($a){ | |
"function 02" | |
} | |
// UDF with two inputs | |
create function testdv1.fun03($b,$c){ | |
$b+$c | |
} | |
for $l in dataset('Metadata.Function') | |
where $l.DataverseName='testdv1' | |
return $l; |