#11463: Alter Procedure option is not provided in Netezza

saima.alvi(*) reported 2014-01-21T11:16:46Z · last modified 2014-06-26T17:41:33Z

Alter Procedure option is not provided in Netezza

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Netezza
Version	15.0

Aqua Data Studio 15.0.0-dev-73

Build #: 35575

Built on: 2014-Jan-17 05:39:06 PM

Database: Netezza 7.0.3

Operational environment:Windows 7(6.1,amd64)/Cp1252/1.7.0_2

Issue:Alter Procedure option is not provided in Netezza

Steps to reproduce:

1)Connect to Netezza->In Any database in query analyzer create a procedure with script

//create procedure

CREATE PROCEDURE "procedure_one"()

RETURNS BIGINT

EXECUTE AS OWNER

LANGUAGE NZPLSQL

BEGIN_PROC

BEGIN

RAISE NOTICE ' This is procedure in Netezza ';

END;

END_PROC

2)Now right click on created procedure (ie Procedure_one)

There is no option provided to alter the procedure.If we alter the procedure through script in query anlyzer procedure is altered successfully.

Synopsis:

ALTER PROCEDURE <name> (<args>) [ RETURNS <type>]

[ EXECUTE AS OWNER | EXECUTE AS CALLER ] [AS <procedure_body>];

ALTER PROCEDURE <name> (<args>) OWNER TO <user>;

1 attachment

doc.png

2014-01-21T11:16:46Z

147 KB

All Comments (1) Change History

ivangron 2014-06-24T21:16:09Z

This is working as designed. If they every provide an ALTER DDL statement that allows for altering the procedure BODY we can revisit and file a enhancement request to support altering the procedure through GUI.

Search Tips

Aqua Data Studio / nhilam

Alter Procedure option is not provided in Netezza

1 attachment

Issue #11463

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Alter Procedure option is not provided in Netezza

1 attachment

Issue #11463

Completion