SELECT char(greatest( abcdefg , defgh , abcfgh , endof... ),20) FROM 

sysibm.sysdummy1;

1                   

endof...            

    1 record(s) selected.

SELECT char(greatest( abcdefg , defgh , abcfgh , endof... , add on ),20) FROM 

sysibm.sysdummy1;

1                   

endof...            

    1 record(s) selected.

SELECT char(greatest( abcdefg , defgh , abcfgh , endof... , add 

on , extra ),20) FROM sysibm.sysdummy1;

1                   

extra               

    1 record(s) selected.

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

bit of ),20) FROM sysibm.sysdummy1;

1                   

extra               

    1 record(s) selected.

352 

MySQL to DB2 UDB Conversion Guide