HI all,
Wanted to ask if there is any way to do FTP using DB2 SQL stored procedures.As we can perfrom this FTP using oracle stored procedures.IS there any equivalent procedure to do it in DB2?
Suggestions wud be appreciated
Thanks.

You do not mention which version od DB2 or OS you are using. In DB2 for LUW, there is no procedure for doing this. You would have to write your own using a programming language like C or Java.

Andy

HI andy
thanks for your reply.I am using db2 v8.1.12 windows.hope this helps....is thr any sample prog or code which I could look at for this equivalent FTP function..
thnx again
Pranay.

Sample code is located at c:\program files\ibm\sqllib\samples.

I do not know if there is any that have FTP in them. That is something you are going to have to write.

Andy