Hi,

I am new in DB2 8.1 below code works/logic works fine in Oracle, pls find below the inline UDF , the intent of this UDF is to create a string for each child and then return the computed string , following query would be fired and it should give result in the stated format



Query
~~~~~~~~~~~~~

SELECT EQUIP_ID , SCH.RANGE(EQUIP _ID) Description
FROM EQUIPMENT
...