470,641 Members | 2,192 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Running OS commands in DB2 UDB stored procedures

Hi all

I am trying to remove files from stored procedure using Linux OS
commands
I know smoe udf needs to be developed either in c or java, but nowhere
code is available
can anyone forward me this code

thanks in advance
Venkat K

Nov 27 '06 #1
3 3117
Venkat Kuppa wrote:
Hi all

I am trying to remove files from stored procedure using Linux OS
commands
I know smoe udf needs to be developed either in c or java, but nowhere
code is available
can anyone forward me this code
"[N]owhere"? Have you installed the application development tools samples?
It's an option during your install which adds a bunch of sample code to
your installation. Including C and Java code. Lots of it.

Good luck!
Nov 27 '06 #2
Venkat Kuppa wrote:
Hi all

I am trying to remove files from stored procedure using Linux OS
commands
I know smoe udf needs to be developed either in c or java, but nowhere
code is available
can anyone forward me this code
Try the following terms in your search engine of choice:

db2 udf "operating system"

The first hit on Google is this article: http://tinyurl.com/lu4wg

Read the article, especially section "Things to be aware of". The
information in there is important because you have to understand the
process context in which routines (stored procedures and UDFs) are
executed. It has an influence on privileges (file access).

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 27 '06 #3
Hi
yes it's done
Thank you very much Mr.Knut Stolze
timely valueble input
thanks again

Venkat Kuppa

Knut Stolze wrote:
Venkat Kuppa wrote:
Hi all

I am trying to remove files from stored procedure using Linux OS
commands
I know smoe udf needs to be developed either in c or java, but nowhere
code is available
can anyone forward me this code

Try the following terms in your search engine of choice:

db2 udf "operating system"

The first hit on Google is this article: http://tinyurl.com/lu4wg

Read the article, especially section "Things to be aware of". The
information in there is important because you have to understand the
process context in which routines (stored procedures and UDFs) are
executed. It has an influence on privileges (file access).

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Tim Marshall | last post: by
9 posts views Thread by Ratfish | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.