× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nisha Gaikwad
nisha.gaikwad(*) reported Oct 22, 2013  · tariqrahiman last modified Nov 18, 2014

Alter Procedure option is missing in drop down list


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
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 
AS
BEGIN_PROC
BEGIN
    RAISE NOTICE 'The customer name is beta';
  END;
END_PROC 
GO
 
 
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;
 
1 attachment
  •  
  •  
  • No shares
  •  
All Comments Change History (2)
Sort 
Tariq Rahiman
tariqrahiman   Oct 22, 2013
Field Old Value New Value
Dev Assignee SachinPrakash (Sachin Prakash) ivangron (Ivan Gron)
Type Bug Feature
Version 14.0 Future - .1
Tariq Rahiman
tariqrahiman   Nov 18, 2014
Field Old Value New Value
Fixed Build 15.0.11-1
Resolution Fixed
Resolved Date Nov 18, 2014 9:43 PM
Status New Closed

Issue #10544
Closed
Fixed
Resolved Nov 18, 2014
 
 
Completion
No due date
Fixed Build 15.0.11-1
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017