Create Procedure

The “Create Procedure” feature enables creation of a new procedure from workbench application window. To experience the advantages of this new feature, connect to a database. Then right click on “Stored Procedures” folder and select “Create Procedure…” from the dropdown list.

 

Stored Procedures Properties

The Stored Procedure Properties window pops up. Select “General” field and specify the new procedure’s name and language.

 

Arguments

Select the “Arguments” field to input the Argument’s name and data type to be used in the procedure. When all the arguments are entered, click Ok.

 

The procedure’s template containing detailed description is automatically generates in new Tab. Due to a limitation related to the system views in Netezza, it is not currently possible to reverse engineer a stored procedure that is more than 64,000 characters long. This limitation will be overcome in a future release of the Workbench.