Appendix C: Using Stored Procedures  Running SQL stored procedures

Appendix C: Using Stored Procedures

Setting up SQL stored procedures

SQL stored procedures are single SQL statements that are statically bound to the database. Once created, these procedures can be used by any client.

The DirectConnect access service does not support creating SQL stored procedures, because the SQL transformation process does not provide support to handle the translation. You must create SQL stored procedure source code outside of DirectConnect.

The access service does not support either dropping SQL stored procedures or granting authorization for them. Both of these functions are target-dependent.





Copyright © 2005. Sybase Inc. All rights reserved. Running SQL stored procedures

View this book as PDF