This 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
