#10544: Alter Procedure option is missing in drop down list

nisha.gaikwad(*) reported 2013-10-22T12:21:31Z · last modified 2014-11-18T21:43:40Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	Future - .1

ADS Version : Aqua Data Studio 14.0.3

Database: Netezza 7.0

Connect Netezza -> Open a query analyzer window and run following scripts

CREATE PROCEDURE "customer"()

RETURNS BIGINT

EXECUTE AS OWNER

LANGUAGE NZPLSQL

BEGIN_PROC

BEGIN

RAISE NOTICE 'The customer name is beta';

END;

END_PROC

Here customer procedure created in procedure folder

Go to procedure folder -> go to on customer procedure ->Right click -> In drop down list Alter Procedure option is not provided.

But we can alter procedure from query Analyzer window to alter procedure from query analyzer window run following script

ALTER PROCEDURE "customer"() AS

BEGIN_PROC

BEGIN

RAISE NOTICE 'The customer name is alpha';

END;

END_PROC;

All Comments (1) Change History

tariqrahiman 2014-11-18T21:43:40Z

This is now implemented with the fix for 12785