Chapter 13: RSPs and Host-Resident Requests

Sybase mode example

The following example shows how to create and execute a host-resident request with variables when in sybase mode:

create procedure seltitle as select * from titles
 where type = @vartitle and total_sales > @varsales

execute seltitle @vartitle=’psychology’, @varsales=2000