Export the ddl of particular function in a file and then run it against the desired DB.
Example:
Export to c:\abc.del of del modified by coldel$ select body from syscat.functions where funcschema='YYY' and funcname='XXX'
Regards,
Rahul


-----Original Message-----
From: Rahul Yadav [mailto:db2udbdba-ezmlmshield-x60342536.[Email address protected]
Sent: Saturday, July 29, 2006 1:52 PM
To: LazyDBA Discussion
Subject: copy UDF

I want to copy some UDF from one datatbase to another in DB2 8.1.Is there any way to copy from there as we can do with tables or if i can see the code for he UDF so that i can copy and execute it in another datatbase???

it is very urgent!!

Thanks in advance.


Best Regards,

Rahul Yadav
Software Engineer
Daffodil Software Ltd.
2nd Floor,Vipul Orchid Plaza,
Sun City,Sector 54,
Gurgaon,India.

Mobile:+91 9868679702


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page