Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

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

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You may write a EXTERNAL UDF

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •