It looks like ADS doesn't support creation/alter/drop of extended stored procedures.
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32300.1570/html/sqlug/sqlug44.htm
Is this something that can be easily added within v16?
At the moment I have to switch to DBArtisan or Toad for Sybase to manage these objects.
In theory its trivial, not sure about practice.
analyzing code changes to support this...
a.) option : with recompile --- trouble find stored value in system catalog tables.
Support is for Sybase 15.5+
1.) Extraction and scripting support. create/ create or replace/ drop
2.) GUI support for create/alter
3.) Drop support from tree node.
4.) Schema Object Scripting support
5.) Multi Object Scripting support
6.) ObjectSearch support
7.) Permissions extraction and scripting support. Script GRANT/REVOKE
Examples:
create procedure ivantestproc_ext
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
as external name sybmail
GO
create procedure ivantestproc_extended
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
with recompile
as external name sybmail
GO
create procedure ivantestproc_extended1
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
with execute as owner
as external name sybmail
GO
create procedure ivantestproc_extended2
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
with execute as caller
as external name sybmail
GO
Examples:
create procedure ivantestproc_ext
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
as external name sybmail
GO
create procedure ivantestproc_extended
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
with recompile
as external name sybmail
GO
create procedure ivantestproc_extended1
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
with execute as owner
as external name sybmail
GO
create procedure ivantestproc_extended2
(@fname varchar(200), @lname varchar(200), @age int, @height bigint, @photo varbinary, @salary decimal(9,2))
with execute as caller
as external name sybmail
GO
I have completed the changes listed above and checked code into version 16 & 17
I have completed the changes listed above and checked code into version 16 & 17
@ivan: Can you add Create Procedure in parent tree node for Extended Stored Procedure Node ?
@ivan: Can you add Create Procedure in parent tree node for Extended Stored Procedure Node ?
create procedure menu item added to extended procedure folder node
create procedure menu item added to extended procedure folder node
I will close this once you fix issue 13769 and do a quick regression
I will close this once you fix issue 13769 and do a quick regression
Issue #13201 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v16.0.3-10, v17.0.0-dev-12 |
No time estimate |
1 issue link |
breaks #13769
Issue #13769Procedure debugger does not show text variables |
analyzing code changes to support this...
a.) option : with recompile --- trouble find stored value in system catalog tables.
Support is for Sybase 15.5+
1.) Extraction and scripting support. create/ create or replace/ drop
2.) GUI support for create/alter
3.) Drop support from tree node.
4.) Schema Object Scripting support
5.) Multi Object Scripting support
6.) ObjectSearch support
7.) Permissions extraction and scripting support. Script GRANT/REVOKE