Variables in host-resident requests  Sybase mode example

Chapter 13: RSPs and Host-Resident Requests

Passthrough mode example

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

create request seltitle select * from titles
 where type = &vartitle and total_sales > &varsales
use request seltitle &vartitle=’psychology’ &varsales=2000




Copyright © 2005. Sybase Inc. All rights reserved. Sybase mode example

View this book as PDF