Overriding and adding to EXEC statements

A parameter with a qualified name (qualified by the procedure step in which it is specified) applies only to the EXEC statement in which it is specified. If a parameter of an EXEC statement that invokes a cataloged procedure has an unqualified name, the parameter applies to all the EXEC statements in the cataloged procedure. For example, REGION=2048 specifies a region size of 2048 for all of the EXEC statements in a given procedure, whereas REGION.GO=2048 applies to only the GO step of the procedure.

If you want to modify a multiple step procedure, you can do so by specifying parameters with qualified names on a step-by-step basis. If you want to modify the entire procedure, specify the name of the parameter in an EXEC statement without qualifying it. The modifications override existing parameters in the cataloged procedure.