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.
49 KB
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