Creating an extgen_ method

To create an extended (extgen_) stored procedure method, use this process:

Open the Edit Stored Procedure form.
From the Stored Procedure drop-down list, select the base stored procedure you want to extend.

A base stored procedure is any stored procedure on the list that does NOT have an "extgen_" prefix in the name.

Note: You can use a wildcard search to more easily locate and select the stored procedure you want, by typing the first few characters and then adding an asterisk (*); for example: extgen_my*
Select the Remove To Extgen option.
Click Copy Procedure.

This opens a copy of the code for the base stored procedure into the text box workspace. This copy adds the "extgen_" prefix to the name and removes the code that checks for extgen_ stored procedures. See the Remove to Extgen entry in Edit Stored Procedure.
In the workspace, alter the code to suit your needs.

Note: You cannot actively and iteratively test your code in this workspace. We recommend that you test your code in a local SQL test environment before submitting it to the database.
When you are finished modifying the code, click Submit.

The application prepends the "extgen_" prefix to the file name and adds the new extended stored procedure to the database.