convert SQL function to DB2

[nimrodman]

Does anyone have an idea on how to convert a SQL Server function to work in DB2? I do really appreciate any assistance, thanks.

The function I want to convert is in the link below, thanks you so much.

http://aspadvice.com/blogs/plitwin/archive/2005/12/23/14445.aspx

 

[Mercury2]

Try this out.

CREATE FUNCTION FNGETTITLE ( AU_ID VARCHAR(11) )               
LANGUAGE SQL                                                   
RETURNS NVARCHAR(2048)                                         
SET OPTION COMMIT = *NONE                                      
                                                               
BEGIN                                                          
DECLARE STRLIST NVARCHAR(2048) DEFAULT ' ';                    
                                                               
FOR V AS C1 CURSOR                                             
  FOR SELECT T.TITLE FROM TITLES T                             
      INNER JOIN TITLEAUTHOR TA  ON T.TITLE_ID = TA.TITLE_ID   
      INNER JOIN AUTHORS A ON TA.AU_ID = A.AU_ID               
      WHERE A.AU_ID = AU_ID                                    
   DO SET STRLIST = TRIM(STRLIST) CONCAT ' ' CONCAT V.T.TITLE; 
  END FOR;                                                     
                                                               
RETURN LTRIM(STRLIST);                                         
END