Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Location
    San Francisco,US
    Posts
    15

    Unanswered: runstats in db2 sql proceedure

    hi all
    can anybody tell me how to call runstat command from a db2 sql procedure.

    ashu
    Ashutosh Mishra
    Accenture India,Chennai
    call on - +91-9884118430

  2. #2
    Join Date
    Apr 2003
    Location
    Florida
    Posts
    79

    Smile

    As far as I know, it is not possible to call a utility from a SQL Procedure -But if you find a way, please publish your findings in the DBforum.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: runstats in db2 sql proceedure

    AFAIK, not from a SQL Procedure ,,,

    Should be possible with Admin APIs in a C Procedure ...

    Cheers


    sathyaram

    Originally posted by amishra
    hi all
    can anybody tell me how to call runstat command from a db2 sql procedure.

    ashu

  4. #4
    Join Date
    Feb 2003
    Location
    San Francisco,US
    Posts
    15

    got the solution

    yeah
    i have got the solution.
    i created once c stored procedure from which i am calling a simple sql file which contains database connection and runstats command on the table.
    i create the dll from the c file then usin gthat dll i created a procedure which i am calling inside my regular sql stored procedure.

    thanks
    ashutosh
    Ashutosh Mishra
    Accenture India,Chennai
    call on - +91-9884118430

Posting Permissions

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