Results 1 to 2 of 2

Thread: Chanfing the SP

  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: Chanfing the SP

    Hi,

    I have modified a Stored procedure for UDB 7.2 on AIX.
    How do I implement the modified SP in the database.

    Is the Drop proc / Create proc enough OR Alter PROC is good option.
    Also do I need to do anything else than this in order to call this proc from application codes?

    Also how do I test the proc using just the command line tools?


    Thanks in advance
    j

  2. #2
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    35
    To change a Stored Proc you need to drop/re-create. To execute a Stored Proc look at the CALL command which look like this:

    CALL schema.storedprocname ();

    empty () implies their are no variable that are pass.

    HTH,

    Dany

Posting Permissions

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