SQL$HELP_OLD72.HLB  —  ALTER  PROCEDURE  Format
  ALTER PROCEDURE <proc-name> ---++-> COMMENT IS +-> '<string>' -------+++->
                                 ||              +------- / <----------+||
                                 |+-> COMPILE --------------------------+|
                                 |+-> NAME <external-body-name> --------+|
                                 |+-> external-location-clause ---------+|
                                 |+-> LANGUAGE language-name -----------+|
                                 |+-> notify-clause --------------------+|
                                 |+-> bind-site-clause -----------------+|
                                 |+-> bind-scope-clause ----------------+|
                                 |+-> RENAME TO <new-procedure-name> ---+|
                                 +--------------<------------------------+

  external-location-clause =

  ---+--> DEFAULT LOCATION ------------+-------------------------+
     +--> LOCATION '<image-location>' -+                         |
   +-------------------------------<-----------------------------+
   +-+----------------------------->--------------------------+-->
     +--> WITH --+-> ALL -----+--> LOGICAL_NAME TRANSLATION --+
                 +-> SYSTEM --+

  notify-clause =

  -> NOTIFY notify-entry-name --> ON -+-+-> BIND ---------+-+->
                                      | +-> CONNECT ------+ |
                                      | +-> TRANSACTION --+ |
                                      +--------- , <--------+

  bind-site-clause =

  --> BIND ON --+--> CLIENT --+--> SITE --->
                +--> SERVER --+

  bind-scope-clause =

  ---> BIND SCOPE --+-> CONNECT ------+-->
                    +-> TRANSACTION --+
Close Help