the store procedure will return a result sets
how can I call the procedure and get the result sets?
thanks!
how can I call the procedure and get the result sets?
thanks!
CREATE FUNCTION MySchema/GetAddress (ParAddrNo Integer)
RETURNS TABLE
(FirstName CHARACTER( 15 ) ,
Name CHARACTER( 15 ) ,
ZipCode DECIMAL (5, 0),
City CHARACTER( 15 ))
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL DATA
CALLED ON NULL INPUT
NO EXTERNAL ACTION
DISALLOW PARALLEL
RETURN Select * from MyFile
Where MyAddrNo = ParAddrNo;
Select FirstName, Upper(LastName)
from Table(GetAddress(MyAddrNo)) as MyUDTF
Where ....
Order by Upper(LastName), FirstName;
Comment