How can I call a korn shell script form a dynamic sql statement?

M_RAS · #1 (**permalink**) 08-25-04, 12:08

Hi All,
I am working with db2 v7.2 fix 6 aix 5.2.
I am going to write a compound dynamic sql statement and I need call a korn shell script, how can I do that , please advise.
thanks

sathyaram_s · #2 (**permalink**) 08-25-04, 12:18

You may write a EXTERNAL UDF

Cheers
Sathyaram

M_RAS · #3 (**permalink**) 08-26-04, 09:32

Quote:

Originally Posted by sathyaram_s

You may write a EXTERNAL UDF

Cheers
Sathyaram

Thank you sathyaram, do you know any reference or example, I have not written before.

Thanks again

sathyaram_s · #4 (**permalink**) 08-26-04, 16:32

http://www-106.ibm.com/developerwork...0302izuha.html

should give an example ...

You can call a shell script from within a C or Java code

Cheers
Sathyaram

Internet Services

Web Development

Digital Marketing

Consumer Tech