SELECT char(greatest( abcdefg , defgh , abcfgh , endof... , add on , extra , a 

bit of , more ),20) FROM sysibm.sysdummy1;

1                   

more                

    1 record(s) selected.

SELECT char(greatest( abcdefg , defgh , abcfgh , endof... , add on , extra , a 

bit of , more , more and  ),20) FROM sysibm.sysdummy1;

1                   

more and            

    1 record(s) selected.

SELECT char(greatest( abcdefg , defgh , abcfgh , endof... , add on , extra , a 

bit of , more , more and  ,  something ),20) FROM sysibm.sysdummy1;

1                   

more and            

    1 record(s) selected.

A.5  Sample code for LEAST

Example A 19 is a set of UDF examples emulating the behavior of MySQL's 

LEAST function. The various UDFs accept input parameters in 

varchar 

and from 

2 to 10 input parameters.

 Appendix A. Sample code for user defined functions 

353