Member Avatar for xuexue

i want to combine multiple rows into a single row using DB2.

I have found this code, but I do not know how can i edit it>?

CREATE FUNCTION MySchema/MyUDF (
PARCol2 CHAR(5) )
RETURNS VARCHAR(1024)   
LANGUAGE SQL 
NOT DETERMINISTIC 
READS SQL DATA 
CALLED ON NULL INPUT 
DISALLOW PARALLEL 

 BEGIN 
  DECLARE ReturnVal VARCHAR(1024) NOT NULL DEFAULT '';

  FOR CsrC1 AS C1 CURSOR 
      FOR SELECT MyCol1 
             FROM MyTable 
             WHERE MyCol2 = ParCol2 
      DO SET ReturnVal = ReturnVal Concat CsrC1.MyCol1; 
  END FOR; 

  RETURN LTRIM(ReturnVal); 
 END  ;

and call it here

Select  id, MyUDF(Name) as FruitsAvailable
     From TableFoo 
     where id = 1

Thanks!

  • 2 Contributors
  • 1 Reply
  • 2K Views
  • 11 Months Discussion Span
  • Latest Post Latest Post by Nate_3
Member Avatar for Nate_3

What exactly are "You" trying to concat?
What does your table look like?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.