+ New Ticket

Reverse engineer stored procedures

Comments

2 comments

  • Avatar
    Chris Rodgers

    The easiest and most accurate way to get the source of the stored procedure is to use Netezza's ddl scripts.  On the server should be a script called:/nz/support/bin/nz_ddl_procedure.  Simply pass it the database and procedure name and you will see the SQL required to (re)create that stored procedure.  If you are not sure of the procedure name, use the script /nz/support/bin/nz_get_procedure_names to list the stored procedures in a particular database.

    0
    Comment actions Permalink
  • Avatar
    MMody

    Thanks, this is helpful.  I was seeing if any tool or method to show a visual of lineage and dependencies.

    Thank you

    0
    Comment actions Permalink

Please sign in to leave a comment.