Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2002
    Posts
    25

    Unanswered: executing db2 commands from a SP

    How do i execute DB2 commands like 'LIST DB DIRECTORY', or 'LOAD'
    from within a stored procedure.

    I tried creating a dynamic sql statement to execute the LOAD utility but it does not work.

    A PDF file "SQL Procedures - Overview" does say that from a SP we can execute db2 commands.
    Does any one know how to do it?
    Thanks and Regards,
    Vijay

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Re: executing db2 commands from a SP

    The thing you're looking for is the administrative API from DB2 UDB (give a look at the book "Administrative API Reference"). You will find some sample code for using it too.
    Rodney Krick

  3. #3
    Join Date
    Jul 2002
    Posts
    25

    Re: executing db2 commands from a SP

    Thanks a lot that really helps
    -Vijay

  4. #4
    Join Date
    Apr 2013
    Posts
    13

    Command use to ...

    Hi All, may i know what is the command used?

    Thanks...

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Why are you resurrecting a post nearly 11 years old?

    And why not follow the advice and read the manual?

    Andy

  6. #6
    Join Date
    Apr 2013
    Posts
    13
    Quote Originally Posted by ARWinner View Post
    Why are you resurrecting a post nearly 11 years old?

    And why not follow the advice and read the manual?

    Andy
    If i can find the solution, do you think I will post the same question? If you cannot answer and don't know the answer, please just shut your mouth. What's wrong i am asking the same question if i know the answer

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My points are this:

    1) you are asking a question, which was answered satisfactorily 11 years ago. Instead of asking the question in a new thread, you bring up this one. If you question is different then ask it.

    2) You need to be able to read directions before you post. Please read the "MUST READ BEFORE POSTING" sticky (here I will even make it easier for you by posting the link:
    http://www.dbforums.com/db2/854783-m...e-posting.html


    We are willing to help, but you need to be able to:

    1) supply us with proper information (see the previous link supplied)
    2) ask the question is a coherent manner (reasking an old post, on that post will not get you too far.
    3) leave your emotions out of it. they do not help.

    Andy

Posting Permissions

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