Aqua Data Studio 15.0.9-5
Build #: 40634
Built on: 2014-Oct-16 05:39:06 PM

Operating Environment: Linux (3.13.0-37-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19

 

Memory: Max=704,643,072;  Total=374,341,632;  Free=132,784,296;  CPUs=8

 

Steps to Reproduce :

 

1. Connect to Sybase anywhere 16 and open query analyzer

2. Run below scripts

 

CREATE TABLE "DBA"."Person_info" (

"p_id" integer NOT NULL,

"p_name" char(25) NOT NULL,

"p_city" varchar(25) NOT NULL,

"p_age" tinyint NOT NULL,

"p_salary" float NOT NULL,

PRIMARY KEY CLUSTERED("p_id"),

PCTFREE 4

)

IN system

GO

ALTER TABLE "DBA"."Person_info"

ADD CONSTRAINT "ch1"

CHECK (p_salary > 0)

GO

GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER ON

"DBA"."Person_info" TO "DBA" WITH GRANT OPTION

GO

 

//1

 

CREATE TRIGGER "DBA"."check_p_no"

AFTER INSERT ON "DBA"."Person_info"

REFERENCING NEW AS new_per

FOR EACH ROW

BEGIN

DECLARE err_user_error EXCEPTION

FOR SQLSTATE '99999';

IF new_per.p_id >10 THEN

SIGNAL err_user_error;

END IF;

END;

Go

 

//2]

 

CREATE TRIGGER "DBA"."check_id"

BEFORE UPDATE

ON "DBA"."Person_info"

REFERENCING OLD AS before_update

NEW AS after_update

FOR EACH ROW

BEGIN

IF after_update.p_id < 2 THEN

RAISERROR 30002 'You cannot update';

END IF;

END

GO

 

3. Select above two triggers, right click on them and select -> Script Object to Windows as -> DROP

 

Here we observed that it will display the message "Selection of scriptable objects is empty"

 

Please see attached screenshot

 

Observation :

1] Same issue is observable for Script Object to New Windows as , Script Object to File as option