When in sybase mode, use this 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 T-SQL:
Numbered procedures
Default parameter argument values
The with recompile option
The first two cause errors; the third is ignored.
