Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Chennai
    Posts
    6

    Unanswered: DDL for Stored Procedures

    Hi all,
    Is there any API to extract DDL for Stored Procedures from UDB7.0 ?
    Or is there any other way .
    Thanks in Advance,
    Vigneshwaran

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi ,
    I think there is no such API.
    Instead you can get the DDL through this query:

    select TEXT from SYSIBM.SYSPROCEDURES

    -Prashant G Dahalkar
    Prashant

Posting Permissions

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