;

   GREATEST function with ten parameters

CREATE FUNCTION GREATEST (P1 VarChar(254), P2 VarChar(254), P3 VarChar(254), P4 

VarChar(254)

                        , P5 VarChar(254), P6 VarChar(254), P7 VarChar(254), P8 

VarChar(254)

                        , P9 VarChar(254),P10 VarChar(254))

 RETURNS VarChar(254)

 LANGUAGE SQL

 SPECIFIC GREATESTOracle10

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

 GREATEST(GREATEST(P1,P2,P3,P4,P5),GREATEST(P6,P7,P8,P9,P10))

;

Example A 18 shows the results of UDFs GREATEST.

Example: A 18   Result of UDFs mapping GREATEST

SELECT char(greatest( abcdefg , abcfgh ),20) FROM sysibm.sysdummy1;

1                   

abcfgh              

    1 record(s) selected.

SELECT char(greatest( abcdefg , defgh , abcfgh ),20) FROM sysibm.sysdummy1;

1                   

defgh               

    1 record(s) selected.

 Appendix A. Sample code for user defined functions 

351