Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    34

    Unanswered: Stored procedure question

    How to see the contents of the stored proc!? (like sp_help <stored proc name> in sybase)

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

    Re: Stored procedure question

    You mean the stored procedure text ?

    export to procname.del of del
    select text from syscat.procedures where procname=<procname>

    This command will export the procedure text to the file ...

    Remember, only SQL SPs have the Text column populated ...

    BTW, if you are on V8, syscat.routines is the view which will have this information

    Sathyaram



    Originally posted by asram
    How to see the contents of the stored proc!? (like sp_help <stored proc name> in sybase)
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Posts
    34
    Thank you. You are the man....

Posting Permissions

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