The starting place should the Information Center topic on <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/sqlp/rbafyroutines.htm”>Database Routines</a>. The Related Information topic under Database lists numerous other resources.
One listed resource that you might find particularly useful is the <a href=”http://www.redbooks.ibm.com/abstracts/sg246503.html?Open”>Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries</a> Redbook.
And, of course, the actual SQL Reference manuals will always be needed for reference about the SQL statements themselves. (They can be downloaded from the Information Center.)
However, since the purpose is “cross-platform compatibility”, you might want to be familiar with how other platforms do things. You won’t find a lot of IBM info on how to port <b>from</b> DB2 to other RDBMSs — you’ll have to go to other vendors to see what porting guides they offer. But maybe the <a href=”http://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/servers/enable/site/db2_porting_i.html”>IBM DB2 for i Porting Information</a> page will be helpful. It can help with how to port specifications from some others to DB2, so you might be able to work out how to go in the opposite directions.