When in sybase mode (or TSQL2 backward-compatible mode), use the following syntax to create a request:
create procedure requestname as request command
For example:
create procedure selauth as select * from authors
The DB2 access service does not support the following create procedure features of Transact-SQL™:
Numbered procedures
Default parameter argument values
The with recompile option
The first two cause errors; the third is ignored.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
